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

187 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
dissect10361413(None) 
disject17268671disject
disseat83816921disseat
dissects11279241dissects
dissent84018681dissent
dissert83720691dissert
bisect10312872bi_sect
dessert82916452dessert
dialect101210262dialect
direct93817332di_rect
discept12310622discept
disjects18275922disjects
disseats93211502disseats
dissected13108662dissected
dissector1245522dissector
dissed85220182disse_d
dissents93411862dissents
disserts92411812disserts
disses75225962disse_s
distent84120852distent
insect83916582_insect
misseat93617232misseat
missent94318712missent
misset85028152misse_t
aspect10612823_aspect
assent65119953_assent
assert64922583_assert
asset55932263_asse_t
basset85225383basse_t
bassett94213863bassett
bisects1137133bi_sects
cosset84125863cosse_t
defect124816173d_efect
deflect13399973deflect
deject164512843d_eject
densest83112473densest
descent102616293descent
deselect1147523deselect
desert72725493d_esert
desserts9247923desserts
detect94217403d_etect
dialects11126003dialects
diciest103316523diciest
didact10711203di_dact
didst74619613dids__t
diesel74410403diese_l
diesels8429143diesels
dieses75218693diese_s
diet57357533di__e_t
digest84019623di_gest
diluent8310263diluent
dimmest1249253dimmest
dioecy1235543di_oecy
dipnet91317473dipne_t
dipshit1347993dipshit
directs102710263di_rects
direst75024243di_rest
disaffect1873103disaffect
disc76123233di_s_c_
discant103017253discant
disced104914653disce_d
discepts1336743discepts
discern1038493discern
disci85815023di_s_ci
disco85616073di_s_co
discreet11413183discreet
discs85316263di_s_cs
diseur738843di_seur
disgust937633disgust
dished114318713dishe_d
dishelm1335833dishelm
disherit12412523disherit
dishes104622653dishe_s
dishiest12313683dishiest
disinfect1545043disinfect
disjected2086353disjected
disjunct1843963disjunct
disked125015763diske_d
diskette1346753diskette
dismast10311233dismast
disme85716243disme__
dismes95617673disme_s
dispart101115283dispart
dispel9310323dispe_l
dispels10310503dispels
dispend11289413dispend
disport101015953disport
disrespect1553393disrespect
disroot8413563disroot
disrupt1048633disrupt
diss56434483diss___
dissave1139413dissave
disseated11711083disseated
dissecting14139473dissecting
dissection13158613dissection
dissectors1345363dissectors
disseise939853disseise
disseize1847183disseize
dissented1199723dissented
dissenter1059133dissenter
disserted11109813disserted
disserve1287443disserve
dissever12107653dissever
dissident1147693dissident
dissing94517683dissing
distant83519953distant
distend93312073distend
distich13312173distich
distinct11410763distinct
distort81120333distort
distract11313023distract
district11413873district
disuse74012843disuse__
disused93211033disuse_d
disuses84015413disuse_s
ditsiest92111323ditsiest
divert103922813di_vert
divest106820073di_vest
dossed84516633dosse_d
dossel74813643dosse_l
dossels85511603dossels
dosser74417973dosse_r
dosseret91111513dosseret
dossers84516233dossers
dosses76126273dosse_s
exsect1558503_exsect
gusset7316433gusse_t
hissed104114453hisse_d
hisself1335913hisself
hisser94713793hisse_r
hissers104112313hissers
hisses94719353hisse_s
hissiest112911093hissiest
idiolect1144353idiolect
infect113413443_infect
inject153210233_inject
insects93710843_insects
insert64325253_insert
inset54430863_inse_t
inspect1138463inspect
islet54527553_isle_t
issei568573_isse_i
isseis638563_isseis
kismet123414623kisme_t
kissed114412853kisse_d
kisser104212453kisse_r
kissers114211293kissers
kisses104217333kisse_s
misact10316683mi_sact
miseat82925703mi_seat
miskept1538923miskept
mismeet113215163mismeet
mismet103722373misme_t
misseats104011683misseats
missed94423603misse_d
missel85216523misse_l
missels94614813missels
missend104411373missend
misses85130873misse_s
missets94516573missets
missort9314653missort
missout9412663missout
misspelt1247273misspelt
misspent1259173misspent
missuit9911303missuit
pissant91012503pissant
pissed94816933pisse_d
pisser84416383pisse_r
pissers95014753pissers
pisses84525083pisse_s
posset84923253posse_t
prosect11313393prosect
resect84424703_resect
respect11412033respect
russet6319433russe_t
sect67443623___sect
sisses64520603sisse_s
sissiest83412353sissiest
subsect112611843subsect
suspect1158513suspect
tasset65925313tasse_t
trisect939733trisect
vivisect1643783vivisect
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.406440125.6
2DLD Change Limit1340271876.83019623.3
3Display Results1871870.0632968.3
 (SQL Overall)1786911877.29924481.6
 
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.