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

212 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
disserts9241181(None) 
desserts9247921desserts
disseats93211501disseats
dissects11279241dissects
dissents93411861dissents
dissert83720691dissert_
asserts74311792_asserts
deserts82513052d_eserts
dessert82916452dessert_
discepts1336742discepts
discerns1138162discerns
disherits1348232disherits
disjects18275922disjects
disparts11109952disparts
disports111111112disports
disseat83816922disseat_
dissect103614132dissect_
dissent84018682dissent_
disserted11109812disserted
disserve1287442disserve
disserves1388062disserves
disses75225962disse__s
distorts91112352distorts
diverts114412032di_verts
dosserets10145692dosserets
dossers84516232dosser_s
hissers104112312hisser_s
inserts74013992_inserts
kissers114211292kisser_s
misseats104011682misseats
missets94516572misse_ts
missorts1038322missorts
pissers95014752pisser_s
assents74512223_assents
assert64922583_assert_
assets65617663_asse_ts
assorts73310153_assorts
bassets96414823basse_ts
bassetts10407373bassetts
bisects1137133bi_sects
bisters93922613bister_s
bistorts10118813bistorts
cisterns10369573cisterns
cossets95014283cosse_ts
cussers94213403cusser_s
dashers115016863dasher_s
descents112511203descents
desert72725493d_esert_
dialects11126003dialects
dialers83614303dialer_s
diapers104713913diaper_s
diasters92913183diaster_s
dibbers124013173dibber_s
dicers94720743di_cer_s
dickers144117663dicker_s
diesels8429143diese_ls
dieses75218693diese__s
diesters92513603diester_s
diestrus946523diestrus
dieters83216433dieter_s
diets66026643di__e_ts
differs14339973differ_s
digests93610613di_gests
diggers104413393digger_s
dikers114418793di_ker_s
diluents946053diluents
dimers94321093di_mer_s
dimmers123811563dimmer_s
dineros83812333di_neros
diners75525953di_ner_s
dingers94321383dinger_s
dinners83915443dinner_s
dipnets10109033dipne_ts
dippers123615183dipper_s
dipshits1445263dipshits
directs102710263di_rects
dirts66824463di___rts
disarms1039043di_sarms
disasters1039153disaster_s
disbars10310323disbar_s
discants112912023discants
discards1238913discards
discept12310623discept_
discern1038493discer_n
discords1238593discords
discrete11410283discrete
diseurs839403di_seurs
disgusts1045653disgusts
dishelms1444723dishelms
disherit12412523disherit
dishes104622653dishe__s
disject17268673disject_
diskette1346753diskette
diskettes1446573diskettes
dismasts1137513dismasts
dismes95617673disme__s
dispart101115283dispart_
dispels10310503dispe_ls
dispends12308533dispends
disperse111011353disperse
disperses121211773disperses
dispirits1246143dispirits
disport101015953disport_
disposers1238373disposer_s
disroots948623disroots
disrupts1145293disrupts
dissaves1239413dissaves
disseated11711083disseated
dissected13108663dissected
dissector1245523dissector
dissectors1345363dissectors
dissed85220183disse__d
disseise939853disseise
disseises1039333disseises
disseize1847183disseize
disseizes1946823disseizes
dissensus1044353dissensus
dissented1199723dissented
dissenter1059133dissenter
dissenters1197723dissenters
dissertate1145983dissertate
dissertates1245343dissertates
disserting121310853disserting
disserved14107003disserved
dissever12107653dissever
dissevers1386863dissevers
dissidents1245023dissidents
distends10339823distends
distent84120853distent_
distort81120333distort_
distress9311713distress
disturbs1145403disturbs
disuses84015413disuse__s
dithers114016153dither_s
divers105024963di_ver_s
divert103922813di_vert_
divests114510933di_vests
dorsers83516303dorser_s
dosers75723633d_oser_s
dossels85511613dosse_ls
dosser74417973dosser__
dosseret91111513dosseret
dosses76126273dosse__s
dossiers9318043dossier_s
dousers84817273douser_s
dowsers115013533dowser_s
dressers9359863dresser_s
droseras935883droseras
dusters84918363duster_s
exserts1467013_exserts
filberts1334993filberts
fishers134714723fisher_s
fissures1136573fissures
fussers104210813fusser_s
gassers84714633gasser_s
gilberts1134183gilberts
gussets837443gusse_ts
hisser94713793hisser__
hisses94719353hisse__s
inerts64517023_i_nerts
insects93710843_insects
insert64325253_insert_
insets64016133_inse_ts
inverts103211953_inverts
islets64513083_isle_ts
isseis638563_isse_is
issuers746123_issuer_s
kismets13306883kisme_ts
kisser104212453kisser__
kisses104217333kisse__s
lispers94514323lisper_s
listers74026533lister_s
miseats92815793mi_seats
misers85025703mi_ser_s
mismeets12297733mismeets
misparts12108173misparts
misseat93617243misseat_
missels94614813misse_ls
missends11368233missends
missent94318713missent_
misses85130873misse__s
misset85028153misse_t_
missort9314653missort_
missouts1037623missouts
misstarts1145833misstarts
missuits1078023missuits
misterms123711353misterms
misters93927513mister_s
misusers10348083misuser_s
mossers94116193mosser_s
outserts8309803outserts
passers94717753passer_s
pishers123815753pisher_s
pissants1097363pissants
pisser84416383pisser__
pisses84525083pisse__s
possets94212773posse_ts
reasserts945983reasserts
reinserts946423reinserts
rinsers73815743rinser_s
risers64624783ri_ser_s
riskers114011993risker_s
russets738163russe_ts
sieverts1145713sieverts
sisses64520603sisse__s
sisters73721593sister_s
tassets75012773tasse_ts
tossers74713503tosser_s
tussers74313563tusser_s
wisents10249063wi_sents
wishers133215213wisher_s
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.406440125.6
2DLD Change Limit1461622127.29620033.2
3Display Results2122120.0932279.6
 (SQL Overall)1786912127.79522923.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.