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

126 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
mismeets1229773(None) 
mismeet113215161mismeet_
kismets13306882kism_ets
misdeeds12276812misdeeds
misdeems13255652misdeems
miseats92815792mis_eats
misfeeds14315622misfeeds
miskeeps1644162miskeeps
mismates121114562mismates
mismet103722372mism_et_
misseats104011682misseats
missets94516572mis_sets
ailments1039433ailments
bisects1137133bis_ects
discepts1336743discepts
disjects18275923disjects
dismasts1137513dismasts
dismes95617673dism_e_s
disseats93211503disseats
dissects11279243dissects
dissents93411863dissents
disserts92411813disserts
figments1446943figments
filmsets1353413filmsets
fishnets1445633fishnets
fitments1376793fitments
gimlets10338433gi_mlets
islets64513083_is_lets
kismats13257843kism_ats
kismet123414623kism_et_
limpets11329783li_mpets
listees73416673listee_s
mainsheets1542893mainsheets
mammees104411143mammee_s
mammets103911113m_ammets
maumets11369693maum_ets
meets74224613___meets
meseems1165603mes_eems
mestees94617753mestee_s
midgets113910253mi_dgets
midmosts1343773midmosts
midweeks1842383midweeks
millets94216843mi_llets
mimeos104511543mi_m_eos
mimers105520183mi_m_ers
mimes95732023mi_m_e_s
mimeses1139073mi_meses
mimesis1137323mi_mesis
minarets1048843minarets
mindsets1135683mindsets
minuets9259853mi_nuets
miquelets2042343miquelets
misacts1139353mis_acts
misagents1246793misagents
misavers1348063misavers
miscasts1238353miscasts
miscites12313783miscites
miscues11312393miscue_s
miscuts1139183mis_cuts
misdates111113633misdates
misdeals1147233misdeals
misdeed113211053misdee_d
misdeem12217873misdee_m
misdoers1137103misdoers
misdoes10312493misdoe_s
miseat82925713mis_eat_
misedits1147963misedits
misers85025703mis__ers
mises74740563mis__e_s
misevents1456003misevents
misfeed13389683misfee_d
misfits12279663mis_fits
misguess1134643misguess
mishears1338323mishears
mishits122513083mis_hits
miskeep1536403miskee_p
miskept1538923miskept_
misleads11358543misleads
mislies92922283mislie_s
mismakes16129883mismakes
mismarks1645893mismarks
mismate111415353mism_ate
mismated131111333mismated
mismeeting1546243mismeeting
mismoves1537293mismoves
misparts12108173misparts
mispens11311073mis_pens
misrates101318243misrates
misreads11268923misreads
misrefers1445363misrefers
misseat93617243misseat_
missels94614813mis_sels
missends11368233missends
missent94318713missent_
misses85130873mis_se_s
misset85028153mis_set_
missies93423983missie_s
missorts1038323missorts
missouts1037623missouts
missteers1135913missteers
missteps12156143missteps
missuits1078023missuits
mistends11419593mistends
misterms123711353misterms
misters93927513mis_ters
mistiest103018313mistiest
mistreats1148633mistreats
mistress10310703mistress
mists76633903mis___ts
misusers10348083misusers
misuses93216023misuse_s
moments113113123m_oments
mostests1036833mostests
muskets13258643mus_kets
mustees94614923mustee_s
pigments1337343pigments
remeets93712413_remeets
resmelts1046143resmelts
sheets93918503__sheets
skeets104513253__skeets
sleets64318873__sleets
smeeks12428433__smeeks
smelts85412773__smelts
sweets94214433__sweets
tipsheets1442223tipsheets
wisents10249063wis_ents

Search took 10 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 Limit1461621269.12316021.3
3Display Results1261260.0632000.0
 (SQL Overall)1786911269.60918596.2
 
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.