Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “flaxes” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
flaxes16501535(None) 
faxes155726651f_axes
flakes134118871flakes
flames114723691flames
flanes94522421flanes
flares94521701flares
flaxen16518571flaxen
flexes164512951flexes
fluxes165212931fluxes
laxes125430091_laxes
alates64833972alates
axes117337852__axes
blades95221252blades
blames105121862blames
blares85021632blares
blazes174817352blazes
calxes154113032calxes
clades94920462clades
claves115020062claves
coaxes154715632coaxes
elates65032362elates
faces106439432f_aces
fades94932862f_ades
fakes126032482f_akes
falces115216002falces
fames105735922f_ames
fanes84639892f_anes
fares85852872f_ares
fates85139232f_ates
faves115331422f_aves
faxed166220532f_axed
fazes175527212f_azes
feases95422922feases
feazes184514172feazes
fixes154723592f_ixes
flabs105818642fla_bs
flacks154114532flacks
flags95321282fla_gs
flails94313002flails
flairs95711912flairs
flake125119972flake_
flaked144715652flaked
flaker134916172flaker
flakers143613272flakers
flakey164410512flakey
flambes14419502flambes
flame105124442flame_
flamed124618972flamed
flamen115215992flamen
flamens124611062flamens
flamer114919122flamer
flamers124616362flamers
flams105125012fla_ms
flanges113413272flanges
flanks133913402flanks
flans85327972fla_ns
flaps105621382fla_ps
flare84823632flare_
flared105317602flared
flashes133916102flashes
flasks13488672flasks
flats86429742fla_ts
flatus94310782flatus
flawed134712722flawed
flaws115920342fla_ws
flax147325632flax__
flaxier17337982flaxier
flaxiest18298192flaxiest
flaxy189012292flax_y
flayed134414052flayed
flayer124713562flayer
flayers133912032flayers
flays116321052fla_ys
flees85828752fl_ees
flexed17419092flexed
flies85630712fl_ies
flites95122442flites
floes85528142fl_oes
flues84626922fl_ues
flukes135114192flukes
flumes115119732flumes
flutes95421782flutes
fluxed17509672fluxed
flytes123911562flytes
folates103218452folates
foxes156321092f_oxes
frames115119862frames
galaxes1538882galaxes
glaces94218032glaces
glades84820342glades
glares75518872glares
glazes165315642glazes
hoaxes163611692hoaxes
ilexes134510252ilexes
laces76141762_laces
lades65141272_lades
lakes95737652_lakes
lames75445542_lames
lanes54946792_lanes
lares54852632_lares
lases54944762_lases
laves86039152_laves
laxer125420332_laxer
laxest134913362_laxest
lazes145129572_lazes
lexes127225262_lexes
loxes125227472_loxes
luxes124921502_luxes
maxes145629532_maxes
paxes144928422_paxes
places104323702places
plages94520152plages
planes85028082planes
plates85432242plates
plexes155313542plexes
praxes156215182praxes
raxes124729392_raxes
relaxes143215322relaxes
saxes125229342_saxes
slakes104021882slakes
slates64934062slates
slaves95023022slaves
taxes124730822_taxes
waxes155825502_waxes
zaxes215113822_zaxes

Search took 3 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691825510.360496363.9
2DLD Change Limit825511252.47033421.5
3Display Results1251250.0304166.7
 (SQL Overall)1786911252.86062479.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.