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

106 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
dissaving143695(None) 
discasing1339432discasing
diseasing11310832diseasing
dismaying1656822dismaying
disrating11714552disrating
disseating121111782disseating
disserving15117012disserving
dissing94517682diss__ing
dissolving1545112dissolving
dissuading1345722dissuading
missaying1537632missaying
assaying1236003_assaying
deaving123814753d__eaving
deleaving1436263deleaving
depraving1635973depraving
deserving1497903deserving
dialing94318173di__aling
dictating1338883dictating
dieseling1146143dieseling
dilating102714903di_lating
disabling1337753disabling
disarming1338803disarming
disavowing1843953di_savowing
disbanding1545583disbanding
disbarring1445283disbarring
discanting1449453discanting
discarding1547343discarding
discing113914593di_s_cing
discoing12511453di_scoing
disdain938513disda_in_
disdaining1345993disdaining
disdains1037913disda_ins
disfavoring1952573disfavoring
disgracing1586743disgracing
dishing124017103di_s_hing
disking134615493di_s_king
disliking1537313disliking
dismasting1446383dismasting
disowning1446113disowning
disparting1438933disparting
displacing1646413displacing
displaying1746313displaying
disposing1339933disposing
disproving1746293disproving
disputing1337763disputing
disrobing1347703disrobing
dissave1139413dissav__e
dissaved1337313dissav_ed
dissaves1239413dissav_es
dissecting14139473dissecting
disseising1247643disseising
disseizing2147003disseizing
dissenting121310293dissenting
disserting121310853disserting
dissevering1664083dissevering
dissipating1556313dissipating
distain8313783dista_in_
distaining1248903distaining
distains9413603dista_ins
distancing1447083distancing
distasting1248023distasting
disusing1039003di_susing
disvaluing1574433disvaluing
disyoking1844993disyoking
diving113717953di___ving
dossing93313273doss__ing
enslaving1345383enslaving
essaying1235033_essaying
fissuring1344813fissuring
glissading1342253glissading
hissing114213143hiss__ing
issuing836053_iss_uing
jigsawing2141933jigsawing
kissing122911053kiss__ing
lifesaving1741793lifesaving
massaging1346353massaging
messaging1345343messaging
misdating131010663misdating
miseating121215433miseating
misgiving1645593misgiving
mislaying1557913mislaying
misliving1546983misliving
mismaking18118023mismaking
mismating141211823mismating
mismoving1745783mismoving
misnaming1447423misnaming
mispaging1537803mispaging
misrating121014853misrating
misseating131310943misseating
misshaping1844393misshaping
missing103619073miss__ing
misspacing1784983misspacing
misstating13129313misstating
mistaking1699693mistaking
passaging1345613passaging
pissing103914803piss__ing
reshaving1657273reshaving
ripsawing1542873ripsawing
saving104724513___saving
shaving143414333__shaving
slaving113514833__slaving
staving113915703__staving
timesaving1641983timesaving
tissuing935103tiss_uing
visaing11279333vi_sa_ing
wissing113212943wiss__ing

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 Limit1486411066.93621430.4
3Display Results1061060.0462304.3
 (SQL Overall)1786911067.40224140.9
 
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.