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

196 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
misenter1031083(None) 
misenters1139531misenters
misinter1038831misinter
absenter1086772absenter
assenter867702assenter
disinter9310672disinter
dissenter1059132dissenter
lisente71210702lisente_
mesentera1144652mesentera
mesentery1444842mesentery
minter84425102mi__nter
misalter1038342misalter
miseaten10310772miseaten
misentered1345912misentered
misentry1345772misentry
mishanter1446452mishanter
misinfer1345322misinfer
misinters1138182misinters
misrender1286292misrender
mister84728562mis__ter
silenter838872silenter
absented1156613absented
absentee1067663absentee
absenters1156173absenters
assented957513assented
assenters966993assenters
assentor865293assentor
asserter877573asserter
besetter10137983besetter
bimester1236163bimester
bisected1336203bisected
bisector1245193bisector
bister84922763bis__ter
cementer1239193cementer
center84421413__center
consenter11312493consenter
decenter112412163decenter
deserter91211603deserter
diester83013683di_ester
dieter73516773di_e_ter
digester10258433digester
dimeter10411893dime_ter
directer1137583directer
disaster949943disaster
disinters1039713disinters
dispenser12128323dispenser
disputer1137973disputer
dissented1199723dissented
dissenters1197723dissenters
distender11167743distender
disuniter1086203disuniter
diverter12238623diverter
dysentery1643043dysentery
enter54726383___enter
epicenter1395503epicenter
figeater1236953figeater
fomenter1339263fomenter
hinter94021303hi__nter
immenser1244173immenser
incenter102212093incenter
indenter92311443indenter
inserter82312133inserter
insetter8218593insetter
inter55028493_i__nter
inventer112410843inventer
kiester11329973ki_ester
lamenter1038863lamenter
licencer12146133licencer
licenser10155883licenser
licente91210893licente_
lientery1134883li_entery
linter64625343li__nter
listener8158313listen_er
lister64527253lis__ter
livener10278943liven_er
masseter1037063masseter
master84831343mas__ter
meeter83616503m__eeter
meister93114163meis__ter
melter83520113m__elter
mender93520793m__ender
mentee84121293m__entee
mentor8414363m__entor
mesenteric1453643mesenteric
mesenteron1252913mesenteron
messenger1243313messenger
meter75130323m__e_ter
midwinter1542853midwinter
milter84921233mi__lter
mincer104017363mi__ncer
minder94822503mi__nder
miner76933543mi__n_er
minister10410363minister
minster93914323mi_nster
minted94220583mi__nted
minters93822473mi__nters
mintier93615993mi__ntier
minuter93510413mi_nuter
misacted1338673misacted
misalters1136913misalters
misate81222693mis_ate_
misaver1249813mis_aver
miscite11314383miscite_
miscited13310423miscited
miscites12313783miscites
misdate101413963misdate_
misdated121211123misdated
misdates111113633misdates
misdealer1245593misdealer
misdoer1048633mis_doer
misease92713043misease_
miseases102614343miseases
miseat82925713miseat__
miseats92815793miseat_s
misedited1346783misedited
misenrol1044143misenrol
misentering1446373misentering
misentries1247823misentries
miser75430403mis___er
miserere1049273mise_rere
miseries10320403miseries
misesteem1344133misesteem
mishanters1544983mishanters
misinfers1445483misinfers
misknew1633883miskn_ew
mislayer1337503mislayer
misleader1246503misleader
misliker14319573misliker
mismate111415353mismate_
mismated131111333mismated
mismates121114563mismates
misnomer1247143misnomer
misorder1147283misorder
mispenned1445413mispenned
misquoter2043383misquoter
misrate91319143misrate_
misrated111315383misrated
misrates101318243misrates
misrefer1346103misrefer
misrenders1375353misrenders
misseated12610113misseated
missense1037963missense_
missenses1148033missenses
missent94318713missent__
missteer1037223missteer
misstep11158463mis_step
mistaker14109333mistaker
misted93625823mis__ted
mistended13137333mistended
misterm114314513mis__term
misters93927513mis__ters
mistier93418713mis_tier
mistutor1044943mistutor
misuser93210443mis_user
miter75734793mi___ter
miterer92511333mite_rer
modester1197483modester
moistener1145843moisten_er
moister94015373mois__ter
molester1099373molester
mounter93713173m_ounter
muenster1043313m_uenster
musette938433musette_
musettes1037433musettes
muster84724523mus__ter
orienter838313orienter
pilsener1044753pilsen_er
pinsetter1145013pinsetter
presenter11311643presenter
recenter102715443recenter
reenter73217793_reenter
renter64527413__renter
repenter102813863repenter
resented92716963resented
resetter81511833resetter
rimester1037813rimester
ripener937903ripen_er
riveter10208753rive_ter
seater64534163__seater
sender73824413__sender
sente56432883__sente_
setter64023723__setter
silencer1036293silencer
sinter63625923__sinter
sister64421583sis__ter
tenter64623933__tenter
tinter63923643ti__nter
upsetter1034643upsetter
venter94218723__venter
visiter1038863vis_iter
widener11318693widen_er
wiener94513543wi_en_er
winter94222803wi__nter
wiselier1137363wiselier
wisent93516343wisent__
wisents10249063wisent_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 Filter1786911461620.470380193.6
2DLD Change Limit1461621967.36019859.0
3Display Results1961960.0762578.9
 (SQL Overall)1786911967.90622601.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.