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 “mitres” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

125 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
mitres8392207(None) 
litres65220391litres
matres84522231matres
metres85121561metres
mires75640881mi_res
miters84328781miters
mites75141801mit_es
mitre75522421mitre_
mitred94414341mitred
nitres65519331nitres
titres64718931titres
amities9317382amities
antres65021002antres
bistres94017212bistres
biters83925242biters
bites75641172bit_es
cires74932912ci_res
citers85022982citers
cites74435592cit_es
cities84524852cities
citrus83610922citrus
dites66339152dit_es
ditzes163212422ditzes
emigres1037672emigres
fibres114312122fibres
fires85740752fi_res
gites65630182git_es
goitres8389562goitres
hires86134342hi_res
ires45639282_i_res
kiters105218592kiters
kites95432542kit_es
kithes135016652kithes
liters65429882liters
litre55421462litre_
livres94311862livres
madres93718182madres
mares76457632m_ares
maters85032392maters
mates75251362mat_es
mattes85624532mattes
matures9314302matures
meres75143572m_eres
meters85625832meters
metes74736212met_es
metre74821302metre_
metred95315142metred
metros84217802metros
miches134320732miches
micros104115362micros
midges103516472midges
mikes115129892mi_kes
milers84625162milers
miles74645072mi_les
milles84526562milles
milreis937322milreis
milters93619092milters
mimers105520182mimers
mimes95732022mi_mes
minces104420802minces
miners84126632miners
mines75651952mi_nes
minkes124618782minkes
minters93822472minters
minxes154612982minxes
mioses84318852mioses
mire66748232mi_re_
mired85729222mi_red
mirex146816622mi_rex
mirks115122142mi_rks
mirs66940572mi_r_s
mirths114912992mirths
misers85025702misers
mises74740562mi_ses
misses85130872misses
misters93927512misters
mistress10310702mistress
mite66249412mit_e_
miter75734792mit_er
mitered103213232mitered
miterer92511332miterer
miterers10219682miterers
mither114218562mither
mithers123516732mithers
mitier83620672mitier
mitiest93520052mitiest
mitis75425992mit_is
mitises9315542mitises
mitoses9312182mitoses
mitral81314322mitral
mitten83914092mitten
mittens9349882mittens
mitts75523752mit_ts
mixers154513562mixers
mixes147224402mi_xes
mixtures1735752mixtures
moires8915632moires
mores76249642m_ores
motes75944002mot_es
mottes85523692mottes
mures75937212m_ures
murres85019042murres
mutes75033782mut_es
niters64624212niters
nites55736342nit_es
nitre57519682nitre_
nitros64214122nitros
pities83828082pities
rites54442552rit_es
ritzes154812942ritzes
sires55945372si_res
sites56045432sit_es
smiters93414362smiters
smites83921922smit_es
tires55437492ti_res
titers64526412titers
tithes94720212tithes
titles63719922titles
titre54619392titre_
tres46542902__tres
unmitres1036862unmitres
vires84529682vi_res
wires86034912wi_res
wites85536962wit_es
withes124620842withes

Search took 6 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 Filter178691825510.220812231.8
2DLD Change Limit825511255.06316304.8
3Display Results1251250.0761644.7
 (SQL Overall)1786911255.35933344.1
 
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.