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

406 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
dire5664414(None) 
cire65836371cire
dare55848861dare
dere56845901dere
dice75841891dice
die46759651di_e
dike95935761dike
dime76237641dime
dine55555331dine
direr64927071direr
dirge75117071dirge
dirk96326831dirk
dirl57430021dirl
dirt55550381dirt
dite55547551dite
dive85634771dive
dore56353301dore
dure56341811dure
fire76245591fire
hire75538961hire
ire36943171_ire
lire47845291lire
mire66748231mire
sire46150411sire
tire46143351tire
wire75839811wire
acre67330772acre
admire949932admire
adore65723672adore
afire86215912afire
aide56044992aide
air38058392air_
aired66032922aired
airer54927892airer
airn46433832airn
airs46447422airs
airt45757782airt
airy75734152airy
are37874572_are
bare65460522bare
bice86235562bice
bide76041482bide
bier65531832bier
bike106532602bike
bile66147182bile
bine66650862bine
bird76128322bird
birk106326862birk
birl65830472birl
birle75023632birle
biro66131212biro
birr66022362birr
birse74517402birse
bise66437102bise
bite66547002bite
bize155926292bize
bore66051332bore
brie65837902brie
byre95023852byre
care66968372care
cere66741472cere
cine66242942cine
cires74932912cires
cite65640342cite
core67263112core
cure66149122cure
dace76934922dace
dairy97016302dairy
dale55643982dale
dame77140312dame
darb76033532darb
dared75935012dared
darer65230792darer
dares66146702dares
dark95133212dark
darn56434622darn
dart55857872dart
date56443322date
daze147327232daze
de37049542d__e
dee47665822d_ee
deer56739022deer
deice84320032deice
deke95228762deke
dele56843082dele
deme76536282deme
dene56643412dene
derm76031892derm
desire7415302desire
dial55935062dial
diary95016972diary
dib65746942di_b
dibs76233682dibs
diced95824682diced
dicer85426422dicer
dices86434242dices
dicey114819332dicey
dick116432382dick
did56850512di_d
didie74120562didie
dido66528192dido
didy99121502didy
died66137852died
diel59034602diel
diene65720132diene
dies55653522dies
diet57357532diet
dif76846902di_f
diff116228842diff
difs86027322difs
dig57544472di_g
digs66036052digs
diked115024682diked
diker105524552diker
dikes105831332dikes
dikey135116422dikey
dill55239972dill
dim68146492di_m
dimer85625602dimer
dimes85833042dimes
dims75435022dims
din46459462di_n
dined76431992dined
diner65632902diner
dines66449152dines
ding66940952ding
dinge75627302dinge
dink97137802dink
dino56036752dino
dins56652042dins
dint56759052dint
diode74716112diode
diol57329132diol
dip67848982di_p
dips75536912dips
dipt77339322dipt
diram84419472diram
direct93817332direct
direly10311562direly
direst75024242direst
dirges84915102dirges
dirked124912272dirked
dirks105619522dirks
dirled84514902dirled
dirls64720502dirls
dirts66824462dirts
dirty95617802dirty
dis46459892di_s
disc76123232disc
dish86328332dish
disk96625832disk
disme85716242disme
diss56434482diss
dit47071332di_t
dita56032522dita
dites66339152dites
dits56450522dits
ditz146929512ditz
diva85920882diva
dived106321372dived
diver94827802diver
dives95832402dives
dizen155214932dizen
doe47361952d_oe
doer57734702doer
doge66233802doge
dole56550002dole
dome77240732dome
done55747912done
dope76038892dope
dor47253922dor_
dork96531462dork
dorm76834632dorm
dorp76028052dorp
dorr56627722dorr
dors56747602dors
dory85836232dory
dose56442432dose
dote55442882dote
dove85131562dove
doze145829082doze
dree56638322dree
dreg66821652d_reg
drek96321092d_rek
drew86221672d_rew
drib76823262drib
dried75321382dried
drier64423962drier
dries64733672dries
drip76223952drip
drive95318002drive
dry76526032d_ry
duce76933502duce
dude65629662dude
due45249862d_ue
duke95628102duke
dune56137582dune
dupe76630602dupe
dura55232112dura
dured75025402dured
dures65635922dures
durn56127622durn
duro56228022duro
durr55624352durr
dwine95616142dwine
dye75334842d_ye
dyer85522112dyer
dyke126418182dyke
dyne85320932dyne
edile64819492edile
eide55832232eide
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
hide85134632hide
hie67652702hi_e
hike116830392hike
hired95226262hired
hiree85427802hiree
hirer85423122hirer
hires86134342hires
hive106029672hive
ice56737242_ice
idle55423762idle
ired55131872_ired
ires45639282_ires
irk76426362_irk
jibe136323392jibe
jive146123592jive
kibe106523442kibe
kier86526802kier
kike76524782kike
kine85643422kine
kir76535672kir_
kirk76221562kirk
kirn87123432kirn
kirs85831732kirs
kite85338232kite
kore85834162kore
lice66045062lice
lie38264522li_e
lier45942462lier
life75433732life
like86040842like
lime66244932lime
line46965572line
lipe66839732lipe
lira46928682lira
liri45128252liri
lite47054542lite
litre55421462litre
live76540992live
livre85613252livre
lore45850352lore
lure45142462lure
lyre75623792lyre
mare64759332mare
mere67244442mere
mice87442232mice
mike105535292mike
mile66352572mile
mime85736402mime
mine67256172mine
mir57046772mir_
mired85729222mired
mires75640882mires
mirex146816622mirex
miri66730372miri
mirk106729502mirk
mirs66940572mirs
miry96326752miry
mise66043582mise
mite66249412mite
mitre75522422mitre
moire71017322moire
more67154522more
mure65941332mure
nice65534712nice
nide55535782nide
nine45842172nine
nite45943582nite
nitre57519682nitre
nixe115722022nixe
ogre56320742ogre
ore36661832_ore
pare66760842pare
pere66450262pere
pice84641092pice
pie55457402pi_e
pier66035292pier
pike106335212pike
pile65649692pile
pine67755712pine
pipe86434432pipe
pirn67128372pirn
pore66451262pore
pure65543332pure
pyre94925552pyre
quire144917132quire
rare45348432rare
re26153742__re
rice64942912rice
ride55945122ride
rife74632322rife
rile45650532rile
rime65138882rime
ripe66038922ripe
rise45945232rise
rite45849452rite
rive75537722rive
sere46153472sere
shire84727132shire
sice65545592sice
side55444482side
sike87138782sike
sine46560622sine
sipe67341042sipe
sir35746672sir_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
sirs44338332sirs
site47052412site
size135630962size
sore47059532sore
spire75828692spire
sure45447412sure
tare45957622tare
tide55237372tide
tie36557532ti_e
tier44936142tier
tike85534482tike
tile45451442tile
time66235012time
tine45855132tine
tired65228902tired
tires55437492tires
tirl45029922tirl
tiro46832362tiro
titre54619392titre
tore47359322tore
tyre75428252tyre
vibe95124502vibe
vice95732852vice
vide85432752vide
vie65447632vi_e
vier75428152vier
vile76139802vile
vine75643682vine
vireo84816452vireo
vires84529682vires
virl76224472virl
vise75632672vise
vive105426622vive
ware76254722ware
were76238332were
wide85235402wide
wife105228022wife
wile75944372wile
wine74953422wine
wipe94830282wipe
wired95327642wired
wirer85124952wirer
wires86034912wires
wiry106422832wiry
wise75737342wise
wite75443272wite
wive105931752wive
wore77144672wore
yare75636942yare
yipe96722182yipe
yird87018982yird
yirr76513572yirr
yore76335942yore
zaire14311992zaire
zine137036152zine

Search took 2 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.0762351197.4
2DLD Change Limit298724060.90632971.3
3Display Results4064060.0934365.6
 (SQL Overall)1786914061.075166224.2
 
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.