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 “coaxes” 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.

111 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
coaxes15471563(None) 
coaxed165612511coaxed
coaxer153912791coaxer
coaxers164311081coaxers
coxes145430861co_xes
hoaxes163611691hoaxes
axes117337852__axes
boraxes163511632boraxes
boxes145625072bo_xes
cades85440732c_ades
cafes106426922c_afes
cages85936012c_ages
cakes116037672c_akes
calxes154113032calxes
cames97047312c_ames
canes75350372c_anes
capes95441922c_apes
cares77369182c_ares
cases75048382c_ases
cates75951892c_ates
caves105639702c_aves
ceases84427072ceases
chafes145017912chafes
chapes135421872chapes
chares115631802chares
chases115128232chases
clades94920462clades
claves115020062claves
coaches144018692coaches
coacts105314332coacts
coalas87418962coalas
coaled95022712coaled
coaler84121712coaler
coalers94419352coalers
coals76129602coa_ls
coapts104614012coapts
coarse84813902coarse
coasts85719142coasts
coated94927042coated
coatee84327222coatee
coatees93816552coatees
coater84329572coater
coaters93525792coaters
coatis85122602coatis
coats75635002coa_ts
coax136922982coax__
coaxal15387302coaxal
cobles104622882cobles
codes86247292co_des
cokes115537192co_kes
coles76055062co_les
colies84837052colies
comakes154413642comakes
comates114123642comates
combes125321732combes
comes97246992co_mes
comtes106222812comtes
cones76457422co_nes
conges94928172conges
conies84338592conies
contes84432912contes
cooees85621892cooees
copes97747102co_pes
copies104130312copies
copses104922482copses
cores76361852co_res
corses84433462corses
corves115122522corves
coses76949492co_ses
coshes115022782coshes
cosies84932162cosies
cotes76347842co_tes
coupes105022522coupes
coves105539172co_ves
cowages13310942cowages
coxae146115182coxae_
coxed154322812co_xed
cozes166033242co_zes
cozies174521412cozies
cozzes164510892cozzes
crakes124921812crakes
cranes84330752cranes
crapes104727692crapes
crases85532312crases
crates85736062crates
craves115825392craves
crazes174720132crazes
cruxes154911562cruxes
faxes155726652_faxes
flaxes165015352flaxes
foxes156321092fo_xes
goxes135018262go_xes
hoaxed17378872hoaxed
hoaxer16348562hoaxer
hoaxers17327132hoaxers
laxes125430092_laxes
loaves94813852loaves
loxes125227472lo_xes
maxes145629532_maxes
oases55330982_oases
oaves84925612_oaves
oxes116530722_o_xes
paxes144928422_paxes
poxes145325722po_xes
praxes156215182praxes
raxes124729392_raxes
saxes125229342_saxes
soaves94218672soaves
taxes124730822_taxes
waxes155825502_waxes
zaxes215113822_zaxes

Search took 6 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.686260482.5
2DLD Change Limit825511114.59617961.5
3Display Results1111110.0761460.5
 (SQL Overall)1786911115.35833350.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.