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

423 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
mire6674823(None) 
cire65836371cire
dire56644141dire
fire76245591fire
hire75538961hire
ire36943171_ire
lire47845291lire
mare64759331mare
mere67244441mere
mice87442231mice
mike105535291mike
mile66352571mile
mime85736401mime
mine67256171mine
mir57046771mir_
mired85729221mired
mires75640881mires
mirex146816621mirex
miri66730371miri
mirk106729501mirk
mirs66940571mirs
miry96326751miry
mise66043581mise
mite66249411mite
mitre75522421mitre
moire71017321moire
more67154521more
mure65941331mure
sire46150411sire
tire46143351tire
wire75839811wire
acre67330772acre
admire949932admire
afire86215912afire
aide56045002aide
air38058392air_
aired66032922aired
airer54927892airer
airn46433832airn
airs46447422airs
airt45757782airt
airy75734152airy
amice96122872amice
amide86128482amide
amie66339852ami_e
amine75835382amine
amir65129752amir_
amirs75924922amirs
are37874572_are
bare65460522bare
bemire103312802bemire
bice86235562bice
bide76041502bide
bier65531832bier
bike106532602bike
bile66147182bile
bine66650862bine
bird76128322bird
birk106326862birk
birl65830472birl
birle75023632birle
biro66131212biro
birr66022362birr
birse74517402birse
bise66437102bise
bite66547002bite
bize155926292bize
bore66051332bore
brie65837902brie
byre95023852byre
care66968372care
cere66741472cere
cine66242942cine
cires74932912cires
cite65640342cite
core67263112core
cure66149122cure
dare55848862dare
dere56845902dere
dice75841892dice
die46759652di_e
dike95935762dike
dime76237642dime
dine55555332dine
direr64927072direr
dirge75117072dirge
dirk96326832dirk
dirl57430022dirl
dirt55550382dirt
dite55547552dite
dive85634772dive
dore56353302dore
dure56341812dure
eide55832242eide
emigre937052emigre
emir65918702emir_
emirs76116162emirs
empire1039322empire
ere36352772_ere
eyre75525252eyre
fare76354462fare
fere76342232fere
fibre104812842fibre
fice95737112fice
fie67152442fi_e
fife106027702fife
file75446642file
fine75147952fine
fir66744892fir_
fired94829742fired
firer811229252firer
fires85740752fires
firm96026452firm
firn76927502firn
firs76637712firs
five107629742five
fore78351472fore
gibe75927782gibe
gie47149542gi_e
gird65424992gird
girl56226552girl
girn56026862girn
giro55828632giro
girt56646422girt
gite55438612gite
give85829352give
gore55744962gore
gyre84722762gyre
hare76255732hare
here76447102here
hide85134642hide
hie67652702hi_e
hike116830392hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029672hive
ice56737242_ice
imide85716892imide
imine75821062imine
ired55131872_ired
ires45639282_ires
irk76426362_irk
jibe136323392jibe
jive146123592jive
kibe106523452kibe
kier86526812kier
kike76524792kike
kine85643432kine
kir76535682kir_
kirk76221572kirk
kirn87123442kirn
kirs85831742kirs
kite85338242kite
kore85834162kore
lice66045062lice
lie38264522li_e
lier45942462lier
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lira46928682lira
liri45128252liri
lite47054542lite
litre55421462litre
live76540992live
livre85613252livre
lore45850352lore
lure45142462lure
lyre75623792lyre
mabe85733362mabe
mace87345792mace
made75440242made
madre85720172madre
mae57659112m_ae
mage75739132mage
maigre9309162maigre
maile75232222maile
mair66133782mair_
mairs76228302mairs
maize164618562maize
make105537892make
male66052302male
mane65052032mane
mar57965952mar_
mara67444572mara
marc87034632marc
mares76457632mares
marge85328332marge
mark105138062mark
marl66341622marl
mars66261872mars
marse76231152marse
mart66865982mart
mate65154222mate
maze155434982maze
mbira977972mbira
me47748332m__e
meme85330552meme
merc87225622merc
merde84320122merde
merer75126232merer
meres75143572meres
merge84523692merge
merk106027942merk
merl65830972merl
merle75824372merle
mete64438132mete
metre74821302metre
meze154420902meze
mi48249052mi__
mib76946122mi_b
mibs85330482mibs
mic77647642mi_c
mica86428252mica
miche126219242miche
mick126333432mick
micra96214972micra
micro94715992micro
mics87435152mics
mid67354472mi_d
midge95016552midge
midi75628482midi
mids76541792mids
mien65028362mien
miff125625062miff
mig65646082mi_g
migg85716802migg
migs76935322migs
miked125020452miked
mikes115129892mikes
mikra114610312mikra
mil55752112mi_l
mild75330852mild
miler75733062miler
miles74645072miles
milk105028472milk
mill66541482mill
mille75029132mille
milo65536102milo
mils66045332mils
milt65455812milt
mim76048422mi_m
mimed105622732mimed
mimeo96018682mimeo
mimer94825762mimer
mimes95732022mimes
mina65136922mina
minae75627722minae
mince95325232mince
mind75434382mind
mined85333352mined
miner76933542miner
mines75651952mines
mini65634562mini
mink106636532mink
minke115421762minke
mint66758062mint
minx137723352minx
mips85534082mips
mirage92313652mirage
mirier83918362mirier
mirin75023152mirin
mirker123712692mirker
mirks115122142mirks
mirky146315522mirky
mirth106418892mirth
mirza16410442mirza
mis58162622mi_s
miser75430402miser
mises74740562mises
miso67229902miso
miss65339422miss
mist66154532mist
miter75734792miter
mites75141802mites
mitred94414342mitred
mitres83922072mitres
mitt66145492mitt
mity95528212mity
mix126138182mi_x
mixed155717252mixed
mixer145017642mixer
mixes147224402mixes
mixt136831922mixt
mizen164815272mizen
mode75840302mode
moira71012022moira
moires8915632moires
moke106234222moke
mole66251832mole
mome85239352mome
mope86838042mope
mor56855002mor_
mora66641272mora
morae75831192morae
morel75729092morel
mores76249642mores
morn66237562morn
mors65950062mors
morse76032702morse
mort66758832mort
mote67048082mote
moue65835572moue
move96630722move
mule65236972mule
mura65633302mura
mured85726702mured
mures75937222mures
murex145517172murex
murk105527252murk
murr65225132murr
murre74821072murre
muse67136032muse
mute65136872mute
nice65534712nice
nide55535792nide
nine45842172nine
nite45943582nite
nitre57519682nitre
nixe115722022nixe
ogre56320742ogre
ombre94111802ombre
ore36661832_ore
pare66760842pare
pere66450262pere
pice84641092pice
pie55457402pi_e
pier66035292pier
pike106335212pike
pile65649692pile
pine67755712pine
pipe86434432pipe
pirn67128372pirn
pore66451262pore
pure65543332pure
pyre94925552pyre
quire144917132quire
rare45348432rare
re26153742__re
rice64942912rice
ride55945132ride
rife74632322rife
rile45650532rile
rime65138882rime
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
sere46153472sere
shire84727132shire
sice65545592sice
side55444492side
sike87138782sike
sine46560622sine
sipe67341042sipe
sir35746672sir_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sirs44338332sirs
site47052412site
size135630962size
smile74823922smile
smirk116612752smirk
smite75224872smite
sore47059532sore
spire75828692spire
sure45447412sure
tare45957622tare
tide55237382tide
tie36557532ti_e
tier44936142tier
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tired65228902tired
tires55437492tires
tirl45029922tirl
tiro46832362tiro
titre54619392titre
tore47359322tore
tyre75428252tyre
umpire1047892umpire
vibe95124502vibe
vice95732852vice
vide85432762vide
vie65447632vi_e
vier75428152vier
vile76139802vile
vine75643682vine
vireo84816452vireo
vires84529682vires
virl76224472virl
vise75632672vise
vive105426622vive
ware76254722ware
were76238332were
wide85235412wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wiry
wise75737342wise
wite75443272wite
wive105931752wive
wore77144672wore
yare75636942yare
yipe96722182yipe
yird87018982yird
yirr76513572yirr
yore76335942yore
zaire14311992zaire
zine137036152zine

Search took 5 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 Filter178691298720.606294869.6
2DLD Change Limit298724232.28313084.5
3Display Results4234230.546774.7
 (SQL Overall)1786914233.43552020.7
 
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.