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

145 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
misseated1261011(None) 
disseated11711081disseated
misstated1278971misstated
dissected13108662dissected
dissented1199722dissented
disserted11109812disserted
miscreated1547422miscreated
misdated121211122mi_sdated
miseaten10310772mi_seaten
misleared1277452misleared
mismated131111332mi_smated
misrated111315382mi_srated
misrelated1346492misrelated
misseat93617232misseat__
misseats104011682misseat_s
misshaped1744752misshaped
missorted1247032missorted
misspaced1645352misspaced
misstarted1344872misstarted
misstate10711342misstate_
misstates11710632misstates
missuited1257022missuited
mistreated1348422mistreated
assented957513_assented
asserted957903_asserted
basseted1136743basse_ted
bassetted1244693bassetted
bisected1336203bi_sected
caseated11310713_caseated
cosseted1178343cosse_ted
discepted1547523discepted
diseased103011713di_seased
disjected2086353disjected
disrated10915573di_srated
disrelated1247343disrelated
dissaved1337313diss_aved
disseat83816923disseat__
disseats93211503disseat_s
disseised1147863disseised
disseized2046323disseized
dissenter1059133dissenter
dissertated1344443dissertated
disserved14107003disserved
dissipated1446053dissipated
dissuaded1265433dissuaded
fissate103010033fiss_ate_
gusseted1043553gusse_ted
ideated9310973_i_deated
inserted92413053_inserted
insetted9249023_insetted
instated91613343_instated
isleted837523_isle_ted
isolated9410523_isolated
lineated9711063li_neated
massaged1236753mass_aged
masseter1037063masse_ter
meated94222403m___eated
messaged1235543mess_aged
messmate1246393messmate_
messmates1346233messmates
migrated121110513mi_grated
militated1248803militated
misacted1338673mi_sacted
misadapted1642993misadapted
misassayed1652403misassayed
misate81222693mi_s_ate_
misbehaved2152093misbehaved
misbiased1444843misbiased
miscited13310423mi_scited
miscreate1348893miscreate_
miscreates1448103miscreates
misdate101413963mi_sdate_
misdates111113633mi_sdates
misdealer1245593misdealer
misdeed113211053misde__ed
misdeemed1544603misdeemed
misdialed1345513misdialed
misease92713043mi_sease_
miseases102614343mi_seases
miseat82925703mi_seat__
miseats92815783mi_seat_s
misedited1346783misedited
misenter10310833mi_senter
misfeed13389683misfe__ed
misfitted1544963misfitted
misframed1745623misframed
misgraded1446233misgraded
misgrafted1743793misgrafted
misheard1446253mishea_rd
mislead10419973mislea__d
misleader1246503misleader
mislearned1383483mislearned
mislocated15196253mislocated
mismate111415353mi_smate_
mismates121114563mi_smates
misnamed13127593mi_snamed
mispaged1438243mi_spaged
misparted1437263misparted
mispenned1445413mispenned
misplaced1646253misplaced
misplanted1565443misplanted
misplayed1745303misplayed
mispleaded1644133mispleaded
misquoted2144083misquoted
misrate91319143mi_srate_
misrates101318243mi_srates
misread10339723misrea__d
misrelate1147933misrelate_
misrelates1247623misrelates
misrelied1247243misrelied
misrouted1247303misrouted
missaid10310303miss_a_id
misseating131310943misseating
missed94423603miss___ed
missend104411373misse__nd
missense1037963missense_
missenses1148033missenses
missent94318713missent__
misset85028153misse_t__
missets94516573misse_t_s
misshape1545973misshape_
misshapen1643783misshapen
misshaper1644403misshaper
misshapes1645913misshapes
missioned1248603missioned
misspace1446523misspace_
misspaces1546513misspaces
misspelled1543493misspelled
misstamped1742903misstamped
missteered1343553missteered
misstep11158463miss__tep
misstepped1782693misstepped
misstyled1544083misstyled
misted93625823mi_s__ted
mistended13137333mistended
mistermed1438363mistermed
mistraced1439453mistraced
mitigated1347083mitigated
nauseated1045233nauseated
pileated112711133pi_leated
reseated93220263_reseated
seated75131053___seated
sweated113411543__sweated
tesselated1143303tesselated
unseated91317683_unseated

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411456.76321978.6
3Display Results1451450.0632301.6
 (SQL Overall)1786911456.99925530.9
 
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.