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

114 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
dissenter105913(None) 
dissented1199721dissented
dissenters1197721dissenters
assenter867702_assenter
disinter9310672di_sinter
dispenser12128322dispenser
disseated11711082disseated
dissected13108662dissected
dissector1245522dissector
dissent84018682dissent__
dissents93411862dissent_s
disserted11109812disserted
dissever12107652disse_ver
distender11167742distender
misenter10310832mi_senter
absenter1086773_absenter
assented957513_assented
assenters966993_assenters
assentor865293_assentor
asserter877573_asserter
consenter11312493consenter
decenter112412163d_ecenter
descanter1246443descanter
descender1346663descender
deserter91211603d_eserter
diameter1148063diame_ter
diaster82813313dias__ter
diesinker1462513diesinker
diester83013683di__ester
dieter73516773di__e_ter
digester10258433di_gester
dimeter10411893di_me_ter
directer1137583di_recter
disaster949943di_saster
discanted1339333discanted
discepted1547523discepted
discerner1246943discerner
discounter1347023discounter
discreeter1344733discreeter
dishwater1644903dishwater
disinters1039713di_sinters
disjected2086353disjected
diskette1346753diskette_
diskettes1446573diskettes
dismember1643983dismember
dispeller12146983dispeller
dispended14147823dispended
dispense11129783dispense_
dispensed13158773dispensed
dispensers13146743dispensers
dispenses121210763dispenses
disperser12109083disperser
disputer1137973di_sputer
disrupter1244723disrupter
disseat83816923disseat__
disseats93211503disseat_s
dissect103614133dissect__
dissectors1345363dissectors
dissects11279243dissect_s
disseise939853disseise_
disseised1147863disseised
disseisee1047753disseisee
disseises1039333disseises
disseisor1044123disseisor
disseize1847183disseize_
disseized2046323disseized
disseizee1946483disseizee
disseizes1946823disseizes
disseizor1942863disseizor
dissembler1544313dissembler
dissensus1044353dissensus
dissentient1256953dissentient
dissenting121310293dissenting
dissention11188073dissention
dissert83720693dissert__
disserts92411813dissert_s
disserve1287443disserve_
disserved14107003disserved
disserves1388063disserves
dissevers1386863disse_vers
dissipater1344873dissipater
dissolver1345623dissolver
dissuader1175083dissuader
distemper1444853distemper
distended12157923distended
distenders12166733distenders
distent84120853distent__
distincter1345303distincter
distorter1048403distorter
disuniter1086203disuniter
diverter12238623di_verter
dysentery1643043d_ysentery
incenter102212093_incenter
indenter92311443_indenter
inserter82312133_inserter
insetter8218593_insetter
inventer112410843_inventer
lisente71210703li_sente_
listener8158313listen_er
masseter1037063masse_ter
messenger1243313messenger
misenters1139533mi_senters
mishanter1446453mishanter
misinter1038833mi_sinter
misrender1286293misrender
misseated12610113misseated
missense1037963missense_
missenses1148033missenses
missent94318713missent__
passenger1243413passenger
pilsener1044753pilsen_er
pinsetter1145013pinsetter
presenter11311643presenter
silenter838873si_lenter

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.436409841.7
2DLD Change Limit1486411146.90621523.5
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.38824186.7
 
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.