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 “mixedly” with Change Limit: [1] [2] [3]

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

103 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
mixedly203398(None) 
fixedly2133911fixedly
mazedly2234432mazedly
mildly12318242mi_ldly
miserly12329822miserly
mixed155717252mixed__
mutedly1345752mutedly
tiredly1136802tiredly
unmixedly2242272unmixedly
vexedly2143462vexedly
vixenly2043192vixenly
addedly1344293addedly
agedly1136463_agedly
amazedly2342843amazedly
amusedly1483183amusedly
biasedly1443953biasedly
bifidly1684233bifidly
cicely1338833cice_ly
cowedly1635703cowedly
datedly1236023datedly
dazedly2134063dazedly
diddly12389573di_ddly
direly10311563dire_ly
fadedly1535453fadedly
fiddly14328483fi_ddly
finely123011563fine_ly
firefly1635633firefly
fixed165416953fixed__
giftedly1642933giftedly
idly85617323_i__dly
jadedly1934013jadedly
kindly14358843ki_ndly
liefly1266363li_efly
likely13328133like_ly
limitedly1542593limitedly
lively123310813live_ly
lividly1434783lividly
madly115218133m__adly
maidenly1444563maidenly
markedly1843863markedly
massedly1444303massedly
mattedly1443883mattedly
maxed155821193maxed__
mealy104422183m__ealy
medfly1535223m__edfly
medley1298343m__edley
meekly1535193m_eekly
meetly1138673m_eetly
merely111312593mere_ly
micell1098193mice_ll
micella11106823micella
micelle1178343micelle
micells11107683micells
midday13327503mi_dday
middle103414983mi_ddle
middy124812593mi__ddy
miked125020453miked__
milady1236613milad_y
mildewy16353533mildewy
milkily16216553milkily
mimed105622733mimed__
mined85333353mined__
mired85729223mired__
mirkily16266403mirkily
misally121111063misally
misedit10311043misedit
misery114113543mise_ry
misrely12319613misrely
mistily122612343mistily
mixable18259173mixable
mixer145017643mixe__r
mixers154513563mixe_rs
mixes147224403mixe__s
mixible18195093mixible
mizzly19256103mi_zzly
muddly13418603m_uddly
mutely113811653mute_ly
nakedly1534403nakedly
nicely1139493nice_ly
nixed135714223nixed__
notedly1136883notedly
piddly13319143pi_ddly
pixel143911903pixe_l_
pixels15478533pixe_ls
redly94217203__redly
rifely123710033rife_ly
rigidly1235533rigidly
ripely112511153ripe_ly
sixthly2042873sixthly
tiddly11308783ti_ddly
timely113410113time_ly
timidly1334593timidly
unitedly1245793unitedly
veiledly1543153veiledly
vilely1239443vile_ly
vividly1744233vividly
wickedly2142793wickedly
widely133311033wide_ly
wieldy13476183wi_eldy
wifely15429423wife_ly
wildly13328123wi_ldly
wingedly1644013wingedly
wisely122711713wise_ly

Search took 7 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 Filter1786911340270.440406115.9
2DLD Change Limit1340271036.48320673.6
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.96925640.8
 
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.