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 “disliking” 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
disliking153731(None) 
misliking1637111misliking
disking134615492dis__king
dislimning1444882dislimning
disyoking1844992disyoking
misliving1546982misliving
besliming1435493besliming
bilking144413553bi_l_king
declining13129353declining
deliming12310373d_eliming
desiring10312143des_iring
despising13167503despising
despiting13179323despiting
destining11311433destining
dialing94318173dial__ing
dialling10310783dial_ling
dialoging1246313dialoging
dialysing1444483dialysing
dialyzing2344043dialyzing
dicking153617613di__cking
dieselizing2244403dieselizing
diking124320243d___iking
dilating102714903di_lating
diluting10248983di_luting
dinking133618283di__nking
dirking133812603di__rking
dirling93316073dirl__ing
disabling1337753disabling
disarming1338803disarming
discasing1339433discasing
discing113914593dis__cing
discipling1645873discipling
disclaiming1744323disclaiming
disclosing1446613disclosing
discoing12511453dis_coing
disdaining1345993disdaining
diseasing11310833diseasing
disguising1346013disguising
dishing124017103dis__hing
disjoining1965723disjoining
dislike122913453dislik__e
disliked14288553dislik_ed
disliker13358643dislik_er
dislikers14286423dislikers
dislikes132810843dislik_es
dislimn1056103disli_mn_
dislimns1144813disli_mns
dislodging1444403dislodging
dismaying1656823dismaying
dismissing1445063dismissing
disobliging1653013disobliging
disowning1446113disowning
displacing1646413displacing
displaying1746313displaying
disploding1575873disploding
displuming1644373displuming
disposing1339933disposing
disprizing2347923disprizing
disputing1337763disputing
disrating11714553disrating
disrobing1347703disrobing
dissaving1436953dissaving
disseising1247643disseising
disseizing2147003disseizing
dissing94517683dis__sing
distaining1248903distaining
distilling1247793distilling
disuniting1247403disuniting
disusing1039003dis_using
dividing1437183di_viding
divining1338413di_vining
dualizing2047783dualizing
dusking133912053dus__king
filliping1544233filliping
finiking16277073fi_niking
idolising1145893idolising
idolizing2046453idolizing
isling71213883_isl__ing
liking114319583___liking
milking143712763mi_l_king
misaiming1437873misaiming
misciting1439673misciting
misfiling1537223misfiling
misfiring1536973misfiring
misgiving1645593misgiving
miskicking1844243miskicking
mislaying1557913mislaying
mislying1437843misl_ying
mismaking18118023mismaking
mistaking1699693mistaking
mistiming1438913mistiming
misyoking1944923misyoking
risking123914243ris__king
silking123715593si_l_king
slaking123717473__slaking
slicing103514643__slicing
slicking153712593__slicking
sliding93114553__sliding
sliming102913953__sliming
slinking133412983__slinking
sliping103314413__sliping
spiking144312883__spiking
visiting1238393vis_iting

Search took 8 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411037.30020361.8
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.76623009.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.