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

184 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
mistends1141959(None) 
distends10339821distends
missends11368231missends
mistend103812521mistend_
dispends12308532dispends
distend93312072distend_
intends8239962_intends
listens74014132listen_s
minuends1143892minuends
misbinds1345162misbinds
misdeeds12276812misdeeds
misfeeds14315622misfeeds
misleads11358542misleads
mispens11311072mispen_s
misreads11268922misreads
missend104411372missend_
misspends1443852misspends
misted93625822miste_d_
mistended13137332mistended
misterms123711352misterms
misters93927512miste_rs
mistunes10311132mistunes
mittens9349882mitten_s
moistens10268772moisten_s
ascends10388203_ascends
attends8257593_attends
bartends1136793bartends
besteads11307123besteads
bilsteds1134273bilste_ds
bisters93922613biste_rs
cisted95217523ciste_d_
cisterns10369573cisterns
contends112810573contends
descends12266983descends
disbands1237353disbands
dispend11289413dispend_
dissents93411863dissents
distended12157923distended
distender11167743distender
distenders12166733distenders
distent84120853disten_t
existents1644983existents
extends15227113_extends
fastens105511753fasten_s
fiends104110293fi__ends
fisted104218703fiste_d_
glistens9366593glisten_s
hastens106214813hasten_s
histed104420243histe_d_
histones11312803histones
impends12376803_impends
intend72310373_intend_
intents72115703_intents
islands837323_islands
kittens11347583kitten_s
listed74322833liste_d_
listees73416673liste_es
listels74212433liste_ls
listen64816813listen__
listened9168813listened
listener8158313listener
listeners9147323listeners
listers74026533liste_rs
listings93310043listings
malteds10377603malte_ds
martens93714953marten_s
masted94025803maste_d_
masters94628923maste_rs
mastheads1545243mastheads
mastoids1177873mastoids
meisters103313843meiste_rs
mends84927693m___ends
mestees94617753meste_es
mestesos1045223mestesos
mestinos1048163mestinos
middens11379383midden_s
midlands1245543midlands
midterms13284863midterms
miens76118303mi__en_s
mildens10339933milden_s
milted93919943milte_d_
milters93619093milte_rs
minds85427123mi___nds
minsters103813923minste_rs
minted94220583minte_d_
minters93822473minte_rs
minuend1035383minuend_
misadds1136303mis_adds
misagents1246793misagents
misatones1148933misatones
misbind1258273misbind_
misbrands1445153misbrands
misdeals1147223misdeals
misdeed113211053misdeed_
misdeems13255653misdeems
miseats92815783mis_eats
misers85025703mis_e_rs
mises74740563mis_e__s
misevents1456003misevents
misfed124113023misfe_d_
misfeed13389683misfeed_
misfields15223653misfields
mishears1338323mishears
miskeeps1644163miskeeps
mislead10419973mislead_
misled94719313misle_d_
mismeets12297733mismeets
mispen10312173mispen__
mispleads1444203mispleads
misread10339723misread_
misrender1286293misrender
misrenders1375353misrenders
misseats104011683misseats
missed94423603misse_d_
missels94614813misse_ls
missense1037963missense
missenses1148033missenses
missent94318713missen_t
misses85130873misse__s
missets94516573misse_ts
missounds1243533missounds
misspend1345243misspend_
missteers1135913missteers
missteps12156143misste_ps
mistakes141213413mistakes
mistbows1543993mistbows
misteach1545443misteach
mistending1447953mistending
mister84728563miste__r
misterm114314513miste_rm
misteuk1335893miste_uk
misthinks1843353misthinks
mistimes12612613mistimes
mistiness111911633mistiness
misting103623383mistin_g
mistrals101212623mistrals
mistreats1148633mistreats
mistress10310703mistress
mists76633903mist___s
mistune9310653mistun_e
mistuned1157723mistuned
mistypes15116713mistypes
miswords1446603miswords
miters84328783mi_te_rs
mites75141803mi_te__s
mitten83914093mitten__
mittened1136363mittened
mizens174610253mi_zen_s
mizzens17366123mizzen_s
moisten93110143moisten__
moistened1246003moistened
moistener1145843moistener
moisteners1244783moisteners
moistness1146343moistness
mostests1036833mostests
mustangs11255973mustangs
mustards11297883mustards
musted93321073muste_d_
mustees94614923muste_es
mustelids1243583mustelids
musters94522513muste_rs
pistes85325633piste__s
pistons93016373piston_s
portends11358963portends
pretends11299113pretends
protends113010353protends
resends83513713res_ends
scends95213003__scends
sends65528243__s_ends
shends105313773__shends
sisters73721593siste_rs
spends94714473__spends
stands75118053__stands
steads74116223__steads
steeds73814883__steeds
stenos63915773__stenos
stents65019453__stents
subtends1136173subtends
suspends1145143suspends
tends65425583___tends
upsends10265293ups_ends
upstands1144093upstands
wisents10249063wis_ents
wisted104120273wiste_d_

Search took 9 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 Limit1461621847.96618348.2
3Display Results1841840.0802300.0
 (SQL Overall)1786911848.46921099.4
 
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.