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

148 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
disliked1428855(None) 
dislike122913451dislike_
disliker13358641disliker
dislikes132810841dislikes
misliked15319511misliked
disclike15208652disclike_
dishlike16287892dishlike_
disked125015762dis__ked
disklike12206742disklike_
dislikers14286422dislikers
dislimned1344622dislimned
disyoked1745462disyoked
mislike132914832mislike_
misliker14319572misliker
mislikes143311832mislikes
mislived14328782mislived
airlike11310333airlike_
aisled74516183aisl__ed
asslike1137373asslike_
beslimed1335013beslimed
biblike1536893biblike_
bilked134012943bi_l_ked
daisied93410013dais_i_ed
dallied93713613dalli_ed
declined123910883declined
delimed11310723d_elimed
desired9311983des_ired
despised1236923despised
despited1248323despited
destined103312453destined
dialed84716453dial__ed
dialled9510133dial_led
dialoged1146693dialoged
dialysed1344413dialysed
dialyzed2243733dialyzed
dicked144920863di__cked
dieselized2143483dieselized
diked115024683d___iked
dilated93115823di_lated
dilled84122223di_l_led
dillies84122163dilli_es
diluted9248933di_luted
dinked124818353di__nked
dirked124912273di__rked
dirled84514903dirl__ed
dirtied93210853dirti_ed
disabled1248713disabled
disarmed1238643disarmed
discased122510853discased
disced104914653dis__ced
discipled1545673discipled
disclaimed1644413disclaimed
disclosed1347363disclosed
discoed11312483dis_coed
disdained1246023disdained
diseased103011713diseased
disguised1245973disguised
dished114318713dis__hed
dishier113613403dishi_er
disjoined1845833disjoined
disliking1537313disliking
dislimn1056103disli_mn
dislimns1144813dislimns
dislodged1344573dislodged
dismayed1535743dismayed
dismissed1344613dismissed
disobliged1552663disobliged
disowned1336433disowned
displaced1546793displaced
displayed1645883displayed
disploded1446543disploded
displumed1544353displumed
disposed12310943disposed
disprized2247363disprized
disputed1238353disputed
disrated10915573disrated
disrobed1238093disrobed
dissaved1337313dissaved
dissed85220183dis__sed
disseised1147863disseised
disseized2046323disseized
distained1139603distained
distilled1147173distilled
disunited1177273disunited
disused93211033dis_used
disyoke1546233disyoke_
disyokes1656503disyokes
divided13378593di_vided
divined12329693di_vined
divvied1544813divvi_ed
dizzied17236133dizzi_ed
doglike13207453doglike_
dollied93811143dolli_ed
dualized1937403dualized
dusked124112513dus__ked
dustlike1335363dustlike_
filliped1435223filliped
finlike14279063finlike_
fishlike18225873fishlike_
fissiped1444153fissiped
gillied95512313gilli_ed
hiplike1637603hiplike_
idolised1045673idolised
idolized1946003idolized
isled64615993_isl__ed
isleted837523_isleted
jiglike19105333jiglike_
kidlike1137063kidlike_
liked104523813___liked
lilied73913213li_li_ed
liplike1337283liplike_
milked134612573mi_l_ked
milliped1337383milliped
misaimed1338093misaimed
miscited13310423miscited
misfiled14278653misfiled
misfired14238543misfired
miskicked1744063miskicked
misled94719313misl__ed
mislie83219153misli_e_
mislies92922283misli_es
mislikers15317063mislikers
mislive122812693mislive_
mislives132912153mislives
mistimed1339123mistimed
misyoked1834623misyoked
niblike1336703niblike_
piglike14157313piglike_
puslike1347563puslike_
riblike1337333riblike_
risked115514633ris__ked
silked114314813si_l_ked
slaked114318273__slaked
sliced94416313__sliced
slicked144413843__slicked
slimed94915123__slimed
slinked123011383__slinked
sliped95417063__sliped
spiked134915553__spiked
tinlike11248803tinlike_
unliked122411283_unliked
unslaked1338463unslaked
unsliced1138093unsliced
viselike1536923viselike_
visited1168773vis_ited
wiglike15125853wiglike_
willied114611563willi_ed
wisplike1734713wisplike_

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit1461621487.70018982.1
3Display Results1481480.0502960.0
 (SQL Overall)1786911488.17321863.6
 
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.