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

204 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
misseats10401168(None) 
disseats93211501disseats
miseats92815781mi_seats
misseat93617241misseat_
missets94516571misse_ts
disseat83816922disseat_
dissects11279242dissects
dissents93411862dissents
disserts92411812disserts
misdeals1147222misdeals
miseat82925712mi_seat_
mishears1338322mishears
misleads11358542misleads
mismeets12297732mismeets
misreads11268922misreads
missals93914422miss_als
missays124010252miss_ays
misseated12610112misseated
missels94614812misse_ls
missends11368232missends
missent94318712missent_
misses85130872misse__s
misset85028152misse_t_
missorts1038322missorts
missouts1037622missouts
misspeaks1743062misspeaks
misstarts1145832misstarts
misstate10711342misstate
misstates11710632misstates
missuits1078022missuits
mistreats1148632mistreats
assents74512223_assents
asserts74311793_asserts
assets65617663_asse_ts
bassets96414823basse_ts
bassetts10407373bassetts
bisects1137133bi_sects
cossets95014283cosse_ts
desserts9247923desserts
discepts1336743discepts
disjects18275923disjects
disseated11711083disseated
dissect103614133dissect_
dissent84018683dissent_
dissert83720693dissert_
disses75225963disse__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
massas85116463mass_a_s
masses85028713masse__s
masseurs1034923masseurs
meats75034053m___eats
messans92710463mess_ans
messes84924343messe__s
messiahs1343963messiahs
messmate1246393messmate
messmates1346233messmates
miasmas1167743miasma_s
miasmata1244503miasmata
midgets113910253midge_ts
midsts95510053mids__ts
midyears1443403midyears
millets94216843mille_ts
mindsets1135683mindse_ts
minuets9259853minue_ts
mioses84318853miose__s
misacts1139353mi_sacts
misadapts1442833misadapts
misagents1246793misagents
misassays1442533misassays
misate81222693mi_s_ate
misbias1139083misbia_s
miscast11312423mi_scast
miscasts1238353miscasts
misclass1246843misclass
miscreants1445083miscreants
miscreate1348893miscreate
miscreates1448103miscreates
miscuts1139183mi_scuts
misdate101413963mi_sdate
misdates111113633mi_sdates
misdeal1037663misdea_l
misdealt1147983misdealt
misdeeds12276813misdeeds
misdeems13255653misdeems
misdials1137493misdials
misdraws1445753misdraws
misease92713043mi_sease
miseases102614343mi_seases
miseaten10310773mi_seaten
misedits1147963misedits
misers85025703mi_se_rs
mises74740563mi_se__s
misevents1456003misevents
misfeeds14315623misfeeds
misfits12279663mi_sfits
misgrafts1544293misgrafts
mishaps1438723mi_shaps
mishear1238393mishea_r
misheard1446253misheard
mishegaas1562193mishegaas
mishits122513083mi_shits
miskals13369763mi_skals
miskeeps1644163miskeeps
miskept1538923miskept_
mislays12349243mi_slays
mislead10419973mislea_d
mislearn1045343mislearn
mislearns1144523mislearns
mismate111415353mi_smate
mismates121114563mi_smates
mismeet113215163mismeet_
mismet103722373misme_t_
misparts12108173misparts
mispens11311073mispe_ns
misplans1238863misplans
misplants1347313misplants
misplays1555543misplays
mispleads1444203mispleads
misrate91319143mi_srate
misrates101318243mi_srates
misread10339723misrea_d
misrelate1147933misrelate
misrelates1247623misrelates
missaid10310303miss_aid
missal84314903miss_a_l
missay114112143miss_a_y
misseating131310943misseating
missed94423603misse__d
missel85216523misse__l
missend104411373misse_nd
missense1037963missense
missenses1148033missenses
misshape1545983misshape
misshapes1645913misshapes
missies93423983miss_ies
missiles103015083missiles
missions10311903missions
missis84417503miss__is
missises103513693missises
missives133212843missives
missort9314653missort_
missout9412663missout_
misspace1446523misspace
misspaces1546513misspaces
misspeak1643493misspea_k
misspells1343763misspells
misspelt1247273misspelt_
misspends1443853misspends
misspent1259173misspent_
misstamp1443803misstamp
misstamps1543373misstamps
misstart10410043misstart
misstated1278973misstated
missteers1135913missteers
missteps12156143missteps
misstops12176413misstops
missuit9911303missuit_
missus85312293miss__us
missuses10309683missuses
misteach1545443misteach
mistends11419593mistends
misterms123711353misterms
misters93927513miste_rs
mistrals101212623mistrals
mistreat10313113mistreat_
mists76633903mi_s__ts
misusers10348083misuse_rs
misuses93216023misuse__s
mitsvahs1642003mitsvahs
mossers94116193mosse_rs
mosses85527683mosse__s
mostests1036833mostests
muscats1138933m_uscats
muskets13258643muske_ts
muskrats1444313muskrats
mussels9419843musse_ls
musses84624783musse__s
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 7 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.423422437.4
2DLD Change Limit1461622046.32623105.0
3Display Results2042040.0802550.0
 (SQL Overall)1786912046.82926166.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.