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

109 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
dissever1210765(None) 
dissevers1386861dissevers
discover1439562discover
dishevel1564702dishevel
dissave1139412dissave_
dissaved1337312dissaved
dissaves1239412dissaves
dissenter1059132dissenter
disserve1287442disserve_
disserved14107002disserved
disserves1388062disserves
dissevered1544082dissevered
dissolver1345622dissolver
deserver12118383deserver
desilver12286503desilver
diameter1148063diameter
diaster82813313dias_ter
dieseled1035523dieseled
diester83013683dies_ter
dieter73516773di__eter
digester10258433digester
dimeter10411893di_meter
diplexer1844213diplexer
disabler1147913disabler
disarmer1138033disarmer
disaster949943disaster
discerner1246943discerner
discovers1538153discovers
discovert1548793discovert
discovery1845273discovery
diseur738843di_se_ur
disfavor1542873disfavor
dishevels1653633dishevels
dishier113613403di_shier
disinter9310673disinter
disliker13358643disliker
dismaler1137903dismaler
dismember1643983dismember
disobeyer1542693disobeyer
disorder1038133disorder
dispeller12146983dispeller
dispenser12128323dispenser
disperser12109083disperser
disposer11310413disposer
disprover15137073disprover
disputer1137973disputer
disrober1147623disrober
disseat83816923disse_at
disseated11711083disseated
disseats93211503disseats
dissect103614133disse_ct
dissected13108663dissected
dissector1245523dissector
dissects11279243dissects
dissed85220183diss__ed
disseise939853disseise
disseised1147863disseised
disseisee1047753disseisee
disseises1039333disseises
disseisor1044123disseisor
disseize1847183disseize
disseized2046323disseized
disseizee1946483disseizee
disseizes1946823disseizes
disseizor1942863disseizor
dissembler1544313dissembler
dissent84018683disse_nt
dissented1199723dissented
dissenters1197723dissenters
dissents93411863dissents
dissert83720693disse_rt
disserted11109813disserted
disserts92411813disserts
disses75225963diss__es
dissevering1664083dissevering
dissolve1246103dissolve_
dissolved1445593dissolved
dissolvers1444643dissolvers
dissolves1346233dissolves
dissuader1175083dissuader
distaves12311403distaves
distemper1444853distemper
distender11167743distender
ditherer12187763ditherer
ditsier83010293dits_ier
diver94827803di___ver
dosser74417973doss__er
dosseret91111513dosseret
dossier83711693doss_ier
hisser94713793hiss__er
hissier103410503hiss_ier
issuer646623_iss_uer
kisser104212453kiss__er
liever94611863li__ever
listener8158313listener
masseter1037063masseter
misaver1249813mi_saver
misrefer1346103misrefer
missive122413143missive_
missives133212843missives
missteer1037223missteer
passover13135533passover
pilsener1044753pilsener
pisser84416383piss__er
riever94811653ri__ever
sever85426053___sever
sissier73711363siss_ier
soever94412093__soever
whosever1742893whosever

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.450397091.1
2DLD Change Limit1461621096.87621256.8
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.37224239.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.