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

103 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
mistakers1511708(None) 
mistaker14109331mistaker_
mistakes141213411mistake_s
misavers1348062mis_avers
mislayers1445942mislayers
mislikers15317062mislikers
mismakes16129882mismake_s
mistake131312622mistake__
mistaken14147832mistake_n
misters93927512mist__ers
bisters93922613bist__ers
diemakers1645263diemakers
dislikers14286423dislikers
distaves12311403distave_s
intakes11310943_intake_s
listeners9147323listeners
listers74026533list__ers
makers123921733m___akers
mapmakers1944043mapmakers
maskers133913843mas__kers
massagers1245513massagers
masters94628923mast__ers
meisters103313843meist__ers
metamers1249623m_etamers
milkers134411613mi__lkers
milters93619093milt__ers
mimickers1943113mimickers
minsters103813923minst__ers
mintages111110513mintage_s
minters93822473mint__ers
misalters1136913misalters
misaver1249813mis_aver_
miscallers1444303miscallers
misdates111113633misdate_s
misdealers1344613misdealers
misdoers1137103mis_doers
miseases102614343misease_s
misenters1139533misenters
misers85025703mis___ers
mishanters1544983mishanters
misinfers1445483misinfers
misinters1138183misinters
mislabels13114313mislabels
mislabors1344513mislabors
mislayer1337503mislayer_
misleaders1345203misleaders
misliker14319573misliker_
mislikes143311833mislike_s
mismake15139373mismake__
mismates121114563mismate_s
misnames12119883misname_s
misnomers1346183misnomers
misorders1245883misorders
mispages13311183mispage_s
misrates101318243misrate_s
misrefers1445363misrefers
misshapers1743403misshapers
misstates11710633misstate_s
missteers1135913missteers
mistakenly1961513mistakenly
mistaking1699693mistaking
mister84728563mist__er_
misterm114314513mist__erm
misterms123711353mist__erms
mistier93418713mist_ier_
mistimes12612613mistime_s
mistiness111911633mistiness
mistraces13312293mistrace_s
mistress10310703mist_ress
mistunes10311133mistune_s
mistutors1144763mistutors
mistypes15116713mistype_s
misusers10348083mis_users
misyokes1735513misyoke_s
miterers10219683mi_terers
miters84328783mi_t__ers
mithers123516733mi_t_hers
moisteners1244783moisteners
musters94522513must__ers
partakers1536563partakers
retakers123511133_retakers
riskers114011993ris__kers
sakers104125433__s_akers
shakers144015563__shakers
sisters73721593sist__ers
slakers114115753__slakers
soakers114114953__soakers
stackers143413563__stackers
stagers84116673__stagers
stakes103927293__stake_s
stalkers12369853__stalkers
starers74522313__starers
starkers123712393__starkers
staters73922343__staters
stayers103813633__stayers
stokers114515183__stokers
takers103923743___takers
upstagers12173333upstagers
upstaters11174803upstaters
vintagers13123903vintagers
vistaless1254573vistaless
vitamers1334683vi_tamers
wigmakers1943383wigmakers

Search took 7 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.423422437.4
2DLD Change Limit1486411036.34323433.9
3Display Results1031030.0303433.3
 (SQL Overall)1786911036.79626293.6
 
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.