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

276 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
mired8572922(None) 
aired66032921aired
fired94829741fired
hired95226261hired
ired55131871_ired
miked125020451miked
mimed105622731mimed
mined85333351mined
mire66748221mire_
mires75640881mires
mirex146816621mirex
mitred94414341mitred
mixed155717251mixed
mured85726701mured
sired66134281sired
tired65228901tired
wired95327641wired
acred87126352acred
admired1135702admired
aided75828932aided
ailed66240282ailed
aimed85626052aimed
airer54927892airer
airted74214502airted
bared85144482bared
bemired123410632bemired
bided95424962bided
biked125320032biked
biped104718832biped
bird76128312bir_d
birded104414302birded
birled94416992birled
birred94713202birred
bored85034302bored
bred75130972_bred
cared86050092cared
cered85227442cered
cire65836372cire_
cires74932912cires
cited84421952cited
cored85044222cored
cred76530882_cred
cried84624282cried
cured85932132cured
dared75935012dared
diced95824682diced
died66137852di_ed
diked115024682diked
dined76431992dined
dire56644142dire_
direr64927072direr
dirked124912272dirked
dirled84514902dirled
dived106321372dived
dried75321382dried
dured75025402dured
eared65139502eared
erred65915672erred
faired105915772faired
fared95842342fared
fifed125115972fifed
filed95331902filed
fined94930502fined
fire76245592fire_
firer811229252firer
fires85740752fires
firmed125411882firmed
fixed165416952fixed
fried95322912fried
gibed96215962gibed
gied64631982gi_ed
gird65424992gir_d
girded93712492girded
girned84010512girned
girted83912872girted
gored75227082gored
gyred105114092gyred
haired105117172haired
hared95742182hared
heired103813042heired
hided105222442hided
hied85434042hi_ed
hiked135919202hiked
hire75538962hire_
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hived125217912hived
iced78721892_iced
imbed105013632imbed
imped105117972imped
ire36943172_ire_
ires45639282_ires
irid55927162_irid
irked104510922_irked
jibed155114162jibed
jived165115042jived
kirned11408622kirned
kited105120092kited
laired75216812laired
lied55838092li_ed
liked104523812liked
limed85426802limed
lined64934642lined
lire47845292lire_
lived95523722lived
lured65427492lured
maced108528692maced
mailed95326752mailed
maimed114812662maimed
maned86634092maned
mare64759322mare_
mares76457632mares
marked133921622marked
marled95523162marled
marred95421042marred
marted94425212marted
mated85537782mated
mawed115824742mawed
maxed155821192maxed
mayed115522402mayed
mazed175523872mazed
med66146742m__ed
meed74934702m_eed
merde84320122merde
mere67244442mere_
merer75126232merer
meres75143572meres
merged104214942merged
meted85424432meted
metred95315142metred
mewed115218012mewed
mice87442222mice_
miched143913392miched
mid67354452mi__d
mien65028352mi_en
miffed15398712miffed
mike105535282mike_
mikes115129892mikes
mild75330842mi_ld
milded104416152milded
mile66352562mile_
miler75733062miler
miles74645072miles
milked134612572milked
milled94326172milled
milted93919942milted
mime85736392mime_
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
minced114114912minced
mind75434362mi_nd
minded103817832minded
mine67256152mine_
miner76933542miner
mines75651952mines
minored10310102minored
minted94220582minted
mir57046762mir__
miri66730362mir_i
mirier83918352mirier
mirin75023142mirin
mirk106729492mir_k
mirker123712692mirker
mirks115122142mirks
mirky146315522mirky
mirs66940562mir_s
mirth106418892mirth
miry96326742mir_y
mirza16410442mirza
mise66043572mise_
miser75430402miser
mises74740562mises
misfed124113022misfed
misled94719312misled
misread10339722misread
missed94423602missed
misted93625822misted
mite66249402mite_
miter75734792miter
mitered103213232mitered
mites75141802mites
mitre75522422mitre_
mitres83922072mitres
mixer145017642mixer
mixes147224402mixes
mizen164815272mizen
moiled94318862moiled
moire71017312moire_
moires8915632moires
mooed85123982mooed
moored93814172moored
moped105424732moped
more67154522more_
morel75729092morel
mores76249642mores
moved114218152moved
mowed113629012mowed
muled85824432muled
mure65941332mure_
mures75937212mures
murex145517172murex
murid84520582murid
mused85524582mused
muted85023382muted
nided75920872nided
nixed135714222nixed
oared65030652oared
oiled64429472oiled
paired95017522paired
pared86946762pared
pied75035362pi_ed
piked125623312piked
piled85232992piled
pined85935322pined
piped105123162piped
pored85234512pored
pried84426862pried
quired163711942quired
rared65738322rared
red46755802__red
riced85825542riced
riled65833252riled
rimed84826372rimed
riped85226432riped
rived94825612rived
sered65737292sered
shred98125612shred
sided74825952sided
siped84927682siped
sire46150412sire_
siree55238812siree
siren54525822siren
sires55945372sires
sited65130742sited
sized155519242sized
smiled93716432smiled
smirked14307232smirked
sored66141782sored
spired94921862spired
tared69340052tared
tided76322512tided
tied55535212ti_ed
tiered73613972tiered
tiled64832942tiled
timed85223612timed
tined65434532tined
tire46143352tire_
tires55437492tires
tirled74714362tirled
tried65026912tried
tyred95816432tyred
umpired1235782umpired
viced115118182viced
vied86328632vi_ed
vined95626152vined
vireo84816452vireo
vires84529682vires
virid94116042virid
vised95518762vised
waired106015832waired
wared96339872wared
wifed125117742wifed
wiled95231552wiled
wined94434182wined
wiped114722082wiped
wire75839812wire_
wirer85124952wirer
wires86034912wires
wised95123342wised
wited94727142wited
wived125121502wived
wried95518562wried
yird87018982yir_d
yirred10426962yirred

Search took 3 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 Filter178691538000.1401276364.3
2DLD Change Limit538002761.89028465.6
3Display Results2762760.0634381.0
 (SQL Overall)1786912762.09385375.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.