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

162 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
disseats9321150(None) 
disseat83816921disseat_
dissects11279241dissects
dissents93411861dissents
disserts92411811disserts
misseats104011681misseats
desserts9247922desserts
discepts1336742discepts
disjects18275922disjects
disseated11711082disseated
dissect103614132dissect_
dissent84018682dissent_
dissert83720692dissert_
disses75225962disse__s
miseats92815782mi_seats
misseat93617232misseat_
missets94516572misse_ts
assents74512223_assents
asserts74311793_asserts
assets65617663_asse_ts
bassets96414823basse_ts
bassetts10407373bassetts
bisects1137133bi_sects
cossets95014283cosse_ts
defeats113511233d_efeats
descents112511203descents
deserts82513053d_eserts
dessert82916453dessert_
dialects11126003dialects
diesels8429143diese_ls
dieses75218693diese__s
diets66026643di__e_ts
digests93610613di_gests
diktats1235623di_ktats
diluents946053diluents
dingbats1245013dingbats
dipnets10109033dipne_ts
dipsas9359893dips_a_s
dipshits1445263dipshits
diquats1745983di_quats
directs102710263di_rects
disbars10310323di_sbars
discants112912023discants
discept12310623discept_
discerns1138163discerns
disease83213843di_sease
diseases92415813di_seases
diseurs839403di_seurs
disgusts1045653disgusts
dishelms1444723dishelms
disherits1348233disherits
dishes104622653dishe__s
dishpans14115833dishpans
dishrags1346203dishrags
disject17268673disject_
diskette1346753diskette
diskettes1446573diskettes
dismals102010243di_smals
dismast10311233di_smast
dismasts1137513dismasts
dismays13237433di_smays
dismes95617673disme__s
disparts11109953disparts
dispels10310503dispe_ls
dispends12308533dispends
displants1248073displants
displays1446293displays
disports111111113disports
dispreads1346003dispreads
disrate81418523di_srate
disrates91118153di_srates
disroots948623disroots
disrupts1145293disrupts
dissave1139413diss_ave
dissaves1239413dissaves
disseating121111783disseating
dissected13108663dissected
dissector1245523dissector
dissectors1345363dissectors
dissed85220183disse__d
disseise939853disseise
disseises1039333disseises
disseize1847183disseize
disseizes1946823disseizes
dissensus1044353dissensus
dissented1199723dissented
dissenter1059133dissenter
dissenters1197723dissenters
dissertate1145983dissertate
dissertates1245343dissertates
disserted11109813disserted
disserve1287443disserve
disserves1388063disserves
dissever12107653dissever
dissevers1386863dissevers
dissidents1245023dissidents
dissipate1247033dissipate
dissipates1346553dissipates
dissuade1065933dissuade
dissuades1166243dissuades
distends10339823distends
distent84120853distent_
distorts91112353distorts
distracts1249283distracts
disuses84015413disuse__s
diverts114412033di_verts
divests114510933di_vests
dossals8379293doss_als
dossels85511603dosse_ls
dosserets10145693dosserets
dossers84516233dosse_rs
dosses76126273dosse__s
fissate103010033fiss_ate
gussets837443gusse_ts
hissers104112313hisse_rs
hisses94719353hisse__s
inseams9307903_inseams
insects93710843_insects
inserts74013993_inserts
insets64016133_inse_ts
islets64513083_isle_ts
isseis638563_isse_is
kismats13257843ki_smats
kismets13306883kisme_ts
kissers114211293kisse_rs
kisses104217333kisse__s
misdeals1147223misdeals
miseat82925703mi_seat_
mishears1338323mishears
misleads11358543misleads
mismeets12297733mismeets
misreads11268923misreads
missals93914423miss_als
missays124010253miss_ays
misseated12610113misseated
missels94614813misse_ls
missends11368233missends
missent94318713missent_
misses85130873misse__s
misset85028153misse_t_
missorts1038323missorts
missouts1037623missouts
misspeaks1743063misspeaks
misstarts1145833misstarts
misstate10711343misstate
misstates11710633misstates
missuits1078023missuits
mistreats1148633mistreats
pissants1097363pissants
pissers95014753pisse_rs
pisses84525083pisse__s
possets94212773posse_ts
reseats74319583_reseats
russets738163russe_ts
seats54844343___seats
sisses64520603sisse__s
sweats94814613__sweats
tassets75012773tasse_ts
unseats73012853_unseats
wiseass1035823wi_seass
wisents10249063wi_sents
wisses94619603wisse__s

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.1561145455.1
2DLD Change Limit1461621626.79621507.1
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.01525472.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.