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

184 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
dissents9341186(None) 
disseats93211501disseats
dissects11279241dissects
dissent84018681dissent_
disserts92411811disserts
assents74512222_assents
descents112511202descents
desserts9247922desserts
diluents946052diluents
discants112912022discants
discepts1336742discepts
disjects18275922disjects
dispends12308532dispends
disseat83816922disseat_
dissect103614132dissect_
dissensus1044352dissensus
dissented1199722dissented
dissenter1059132dissenter
dissenters1197722dissenters
dissert83720692dissert_
disses75225962disse__s
dissidents1245022dissidents
distends10339822distends
distent84120852distent_
misseats104011682misseats
missends11368232missends
missent94318712missent_
missets94516572misse_ts
pissants1097362pissants
wisents10249062wi_sents
absents93510723_absents
ailments1039433ailments
ascents93812553_ascents
assent65119953_assent_
asserts74311793_asserts
assets65617663_asse_ts
bassets96414823basse_ts
bassetts10407373bassetts
bisects1137133bi_sects
cassenas10317483cassenas
cassenes103611293cassenes
consents102715893consents
cossets95014283cosse_ts
dements103016623d_ements
dents65031803d___ents
descants112910143descants
descends12266983descends
descent102616293descent_
deserts82513053d_eserts
dessert82916453dessert_
detents83615153d_etents
dialects11126003dialects
dickens144410133dicken_s
dienes75719903di__enes
diesels8429143diese_ls
dieses75218693diese__s
diets66026643di__e_ts
digests93610613di_gests
diluent8310263diluent_
dints67431313di___nts
diplonts1146473diplonts
dipnets10109033dipne_ts
dipshits1445263dipshits
directs102710263di_rects
disbands1237353disbands
discant103017263discant_
discept12310623discept_
discerns1138163discerns
discounts1287823discounts
diseurs839403di_seurs
disgusts1045653disgusts
dishelms1444723dishelms
disherits1348233disherits
dishes104622653dishe__s
disject17268673disject_
disjoints1745473disjoints
disjuncts1942723disjuncts
diskette1346753diskette
diskettes1446573diskettes
dismasts1137513dismasts
dismes95617673disme__s
dismounts1275283dismounts
disorients1177793disorients
disowns1136733disown_s
disparts11109953disparts
dispels10310503dispe_ls
dispend11289413dispen_d
dispense11129783dispense
dispenses121210763dispenses
displants1248073displants
disports111111113disports
disroots948623disroots
disrupts1145293disrupts
dissaves1239413dissaves
disseated11711083disseated
dissected13108663dissected
dissector1245523dissector
dissectors1345363dissectors
dissed85220183disse__d
disseise939853disseise
disseises1039333disseises
disseize1847183disseize
disseizes1946823disseizes
dissenting121310293dissenting
dissention11188073dissention
dissentions12168043dissentions
dissentious12184473dissentious
disserted11109813disserted
disserve1287443disserve
disserves1388063disserves
dissever12107653dissever
dissevers1386863dissevers
dissident1147693dissident_
dissing94517683dissin_g
dissolvents1553113dissolvents
distant83519953distant_
distend93312073disten_d
distorts91112353distorts
disuses84015413disuse__s
diverts114412033di_verts
divests114510933di_vests
dizens164911393di_zen_s
docents102810803d_ocents
dossels85511613dosse_ls
dosserets10145693dosserets
dossers84516233dosse_rs
dosses76126273dosse__s
existents1644983existents
figments1446943figments
fishnets1445633fishnets
fitments1376793fitments
ginsengs1042653ginsengs
gussets837443gusse_ts
hissers104112313hisse_rs
hisses94719353hisse__s
hissings12556753hissings
incents92414533_incents
indents83114663_indents
insects93710843_insects
inserts74013993_inserts
insets64016133_inse_ts
intents72115703_intents
invents102812053_invents
islets64513083_isle_ts
isseis638563_isse_is
kismets13306883kisme_ts
kissers114211293kisse_rs
kisses104217333kisse__s
lessens7409383lessen_s
lisente71210703li_sente
listens74014133listen_s
misagents1246793misagents
miseats92815793mi_seats
misevents1456003misevents
mismeets12297733mismeets
mispens11311073mispen_s
misseat93617243misseat_
missels94614813misse_ls
missend104411373missen_d
missense1037963missense
missenses1148033missenses
misses85130873misse__s
misset85028153misse_t_
missorts1038323missorts
missouts1037623missouts
misspends1443853misspends
misspent1259173misspent_
missuits1078023missuits
mistends11419593mistends
pigments1337343pigments
pissant91012503pissant_
pissers95014753pisse_rs
pisses84525083pisse__s
possets94212773posse_ts
presents103315643presents
resents74221223_resents
russets738163russe_ts
scents85317023__scents
silents73514493si_lents
sisses64520603sisse__s
stents65019453__stents
tassets75012773tasse_ts
wisent93516343wi_sent_
wisses94619603wisse__s

Search took 9 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.656272394.8
2DLD Change Limit1461621847.28020077.2
3Display Results1841840.0802300.0
 (SQL Overall)1786911848.01622291.8
 
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.