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

144 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
misinter103883(None) 
disinter9310671disinter
misenter10310831misenter
misinfer1345321misinfer
misinters1138181misinters
disinters1039712disinters
midwinter1542852midwinter
minister10410362minister
minter84425102m__inter
misalter1038342misalter
misenters1139532misenters
mishanter1446452mishanter
misinfers1445482misinfers
mister84728562mis__ter
sinter63625922__sinter
visiter1038862visi_ter
absenter1086773absenter
anointer837823anointer
assenter867703assenter
assister836753assister
bister84922763bis__ter
cointer93616723_cointer
diesinker1462513diesinker
disaster949943disaster
disputer1137973disputer
dissenter1059133dissenter
distincter1345303distincter
disuniter1086203disuniter
diviner11369883divin_er
fainter103611053_fainter
filister1137403filister
hinter94021303__hinter
igniter8147673_igniter
imbitter12265283imbitter
impinger13315423impinger
imprinter1385243imprinter
insister888783insister
inter55028493___inter
jointer14379713_jointer
limiter92710853limi_ter
linter64625343__linter
lisente71210703lisente_
lister64527253lis__ter
magister1136283magister
malinger11116533malinger
mariner93315993marin_er
masseter1037063masseter
master84831343mas__ter
meister93114163m_eister
mesentera1144653mesentera
mesentery1444843mesentery
midwinters1642483midwinters
milliner102811863millin_er
milter84921233m__ilter
mimicker1843313mimicker
mincer104017363m__incer
minder94822503m__inder
miner76933543m__in_er
ministers1139623ministers
miniver1238393mini_ver
minster93914323mi_nster
minted94220583m__inted
minters93822473m__inters
mintier93615993m__intier
minuter93510413mi_nuter
mirier83918363miri__er
misacted1338673misacted
misalters1136913misalters
misate81222693mis_ate_
misaver1249813mis_aver
miscite11314383miscite_
miscited13310423miscited
miscites12313783miscites
misdate101413963misdate_
misdated121211123misdated
misdates111113633misdates
misdoer1048633mis_doer
miseaten10310773miseaten
misentered1345913misentered
misentry1345773misentry
miser75430403mis___er
misfitted1544963misfitted
mishanters1544983mishanters
misinform1643783misinform
misinterred1453353misinterred
misjoinder2052703misjoinder
misknew1633883miskn_ew
mislayer1337503mislayer
misliker14319573misliker
mismate111415353mismate_
mismated131111333mismated
mismates121114563mismates
misnomer1247143misnomer
misorder1147283misorder
mispainted1545013mispainted
mispointed1545573mispointed
misprinted1545983misprinted
misquoter2043383misquoter
misrate91319143misrate_
misrated111315383misrated
misrates101318243misrates
misrefer1346103misrefer
misrender1286293misrender
missileer1145583missileer
missioner1147883missioner
missteer1037223missteer
misstep11158463mis_step
mistaker14109333mistaker
misted93625823mis__ted
misterm114314513mis__term
misters93927513mis__ters
mistier93418713mis_tier
mistutor1044943mistutor
misuser93210443mis_user
miter75734793m__i_ter
mitier83620673miti__er
moister94015373m_oister
mounter93713173m_ounter
muster84724523mus__ter
mutineer1045823mutineer
painter93814563_painter
pointer93814933_pointer
printer93917303_printer
quainter1765903quainter
reinter73116843_reinter
resister8311653resister
sifter94516233__sifter
silenter838873silenter
singer74227313__singer
sinister838583sinister
sinker103620903__sinker
sinner64320603__sinner
sinters74024083__sinters
sister64421583__sister
sitter63323383__sitter
splinter10329703splinter
sprinter103810813sprinter
squinter1747363squinter
stinter73614513_stinter
tinter63923643__tinter
visited1168773visi_ted
visiters1137413visi_ters
visitor1046203visi_tor
winter94222803__winter

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.423422437.4
2DLD Change Limit1461621447.15620425.1
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.63923391.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.