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

134 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
dissaved133731(None) 
dissave1139411dissave_
dissaves1239411dissaves
discased122510852discased
diseased103011712diseased
dismayed1535742dismayed
disrated10915572disrated
disseated11711082disseated
dissed85220182diss__ed
disserved14107002disserved
dissever12107652dissever
dissolved1445592dissolved
dissuaded1265432dissuaded
distaves12311402distaves
assayed1135593_assayed
beslaved1435023beslaved
deaved114916553d__eaved
deleaved1346573deleaved
depraved1535543depraved
deserved13108133deserved
dialed84716453di__aled
dictated1239203dictated
dieseled1035523dieseled
dilated93115823di_lated
dipsades1246493dipsades
disabled1248713disabled
disarmed1238643disarmed
disaster949943disaster
disavow1443603di_savow
disavowed1743883di_savowed
disband1138243disba_nd
disbanded1445643disbanded
disbarred1345273disbarred
discalced1545653discalced
discanted1339333discanted
discard11310213disca_rd
discarded1437083discarded
discase102912863discase_
discases112014503discases
disced104914653di_s_ced
discoed11312483di_scoed
discover1439563discover
disdained1246023disdained
disease83213843disease_
diseases92415813diseases
disfavor1542873disfavor
disfavored1842443disfavored
disgraced1446743disgraced
dished114318713di_s_hed
dishevel1564703dishevel
disked125015763di_s_ked
disliked14288553disliked
dismaler1137903dismaler
dismasted1346833dismasted
disowned1336433disowned
disparted1338853disparted
displaced1546793displaced
displayed1645883displayed
disposed12310943disposed
disproved16147343disproved
disputed1238353disputed
disrate81418523disrate_
disrates91118153disrates
disrobed1238093disrobed
dissaving1436963dissaving
dissected13108663dissected
disseised1147863disseised
disseized2046323disseized
dissented1199723dissented
disserted11109813disserted
disserve1287443disserve_
disserves1388063disserves
disses75225963diss__es
dissevered1544083dissevered
dissevers1386863dissevers
dissipated1446053dissipated
dissolve1246103dissolve_
dissolver1345623dissolver
dissolves1346233dissolves
dissuade1065933dissuade_
dissuader1175083dissuader
dissuades1166243dissuades
distained1139603distained
distanced1348573distanced
distasted1137963distasted
disused93211033di_sused
disvalued1444193disvalued
disyoked1745463disyoked
dived106321373di___ved
dossed84516633doss__ed
enslaved1245063enslaved
essayed1134013_essayed
fissate103010033fissate_
fissiped1444153fissiped
fissured1235183fissured
glissaded1242293glissaded
hissed104114453hiss__ed
issued746723_iss_ued
jigsawed2041813jigsawed
kissed114412853kiss__ed
massaged1236753massaged
messaged1235543messaged
misaver1249813mi_saver
misdated121211123misdated
misgave13298283misgave_
mislived14328783mislived
mismated131111333mismated
mismoved1635653mismoved
misnamed13127593misnamed
mispaged1438243mispaged
misrated111315383misrated
missaid10310303missa_id
misseated12610113misseated
missed94423603miss__ed
misshaped1744753misshaped
missive122413143missive_
missives133212843missives
misspaced1645353misspaced
misstated1278973misstated
passaged1236243passaged
pissed94816933piss__ed
reshaved1536873reshaved
ripsawed1442533ripsawed
saved95127113___saved
shaved135118383__shaved
slaved104017043__slaved
staved103918053__staved
tissued835583tiss_ued
unsaved113312193_unsaved
unshaved15157733unshaved
visaed104110503vi_sa_ed
visaged1235683vi_saged
vistaed1138023vista_ed
wissed104114643wiss__ed

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 Filter1786911461620.626285448.9
2DLD Change Limit1461621346.89021213.6
3Display Results1341340.0462913.0
 (SQL Overall)1786911347.56223630.1
 
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.