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

191 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
disseat8381692(None) 
disseats93211501disseats
dissect103614131dissect
dissent84018681dissent
dissert83720691dissert
misseat93617241misseat
dessert82916452dessert
discept12310622discept
disject17268672disject
disseated11711082disseated
dissects11279242dissects
dissed85220182disse_d
dissents93411862dissents
disserts92411812disserts
disses75225962disse_s
distent84120852distent
miseat82925712mi_seat
misseats104011682misseats
missent94318712missent
misset85028152misse_t
assent65119953_assent
assert64922583_assert
asset55932263_asse_t
basset85225383basse_t
bassett94213863bassett
bisect10312873bi_sect
cosset84125863cosse_t
defeat103817163d_efeat
densest83112473densest
descent102616293descent
desert72725493d_esert
desserts9247923desserts
dialect101210263dialect
diciest103316523diciest
didst74619613dids__t
diesel74410403diese_l
diesels8429143diesels
dieses75218693diese_s
diet57357533di__e_t
digest84019623di_gest
diktat11310693di_ktat
diluent8310263diluent
dimmest1249253dimmest
dingbat1146983dingbat
dipnet91317473dipne_t
dipsas9359893dips_as
dipshit1347993dipshit
diquat1639763di_quat
direct93817333di_rect
direst75024243di_rest
disbar938513di_sbar
discant103017263discant
disced104914653disce_d
discepts1336743discepts
discern1038493discern
discreet11413183discreet
disease83213843di_sease
diseur738843di_seur
disgust937633disgust
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishiest12313683dishiest
dishpan13105523dishpan
dishrag1246273dishrag
disjects18275923disjects
disked125015763diske_d
diskette1346753diskette
dismal92412243di_smal
dismast10311233dismast
dismay12229473di_smay
disme85716243disme__
dismes95617673disme_s
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispend11289413dispend
displant11412223displant
display1336663display
disport101015953disport
dispread1247103dispread
disrate81418523di_srate
disroot8413563disroot
disrupt1048633disrupt
diss56434483diss___
dissave1139413dissave
disseating121111783disseating
dissected13108663dissected
dissector1245523dissector
disseise939853disseise
disseize1847183disseize
dissented1199723dissented
dissenter1059133dissenter
dissertate1145983dissertate
disserted11109813disserted
disserve1287443disserve
dissever12107653dissever
dissident1147693dissident
dissing94517683dissing
dissipate1247033dissipate
dissonant1047473dissonant
dissuade1065933dissuade
distal73615773di_stal
distant83519953distant
distend93312073distend
distort81120333distort
distract11313023distract
distrait9414343distrait
disuse74012843disuse__
disused93211033disuse_d
disuses84015413disuse_s
ditsiest92111323ditsiest
divert103922813di_vert
divest106820073di_vest
dossal75510303doss_al
dossed84516633dosse_d
dossel74813643dosse_l
dossels85511603dossels
dosser74417973dosse_r
dosseret91111513dosseret
dossers84516233dossers
dosses76126273dosse_s
fissate103010033fiss_ate
gusset7316433gusse_t
hissed104114453hisse_d
hisself1335913hisself
hisser94713793hisse_r
hissers104112313hissers
hisses94719353hisse_s
hissiest112911093hissiest
inseam8329993_inseam
insect83916583_insect
insert64325253_insert
inset54430863_inse_t
islet54527553_isle_t
issei568573_isse_i
isseis638563_isseis
issuant748263_issuant
kismat123011673ki_smat
kismet123414623kisme_t
kissed114412853kisse_d
kisser104212453kisse_r
kissers114211293kissers
kisses104217333kisse_s
misdeal1037663misdeal
misdealt1147983misdealt
miseats92815783mi_seats
mishear1238393mishear
miskept1538923miskept
mislead10419973mislead
mismeet113215163mismeet
mismet103722373misme_t
misread10339723misread
missal84314903miss_al
missay114112143miss_ay
misseated12610113misseated
missed94423603misse_d
missel85216523misse_l
missels94614813missels
missend104411373missend
misses85130873misse_s
missets94516573missets
missort9314653missort
missout9412663missout
misspeak1643493misspeak
misspelt1247273misspelt
misspent1259173misspent
misstart10410043misstart
misstate10711343misstate
missuit9911303missuit
mistreat10313113mistreat
pissant91012503pissant
pissed94816933pisse_d
pisser84416383pisse_r
pissers95014753pissers
pisses84525083pisse_s
posset84923253posse_t
reseat64131493_reseat
russet6319433russe_t
seat47575563___seat
sisses64520603sisse_s
sissiest83412353sissiest
sweat85628403__sweat
tasset65925313tasse_t
tissual745193tissual
unseat64221023_unseat
wisent93516343wi_sent
wisest95016443wi_sest
wissed104114643wisse_d
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 Filter1786911340270.423422437.4
2DLD Change Limit1340271916.53020524.8
3Display Results1911910.0802387.5
 (SQL Overall)1786911917.03325407.5
 
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.