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

529 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
ires4563928(None) 
ares45871021ares
cires74932911cires
fires85740751fires
hires86134341hires
ices66129641ices
ides57734231ides
ire36943171ire_
ired55131871ired
iris45732551iris
irks86220131irks
mires75640881mires
ores46056681ores
res35565041_res
sires55945371sires
tires55437491tires
tres46542901tres
vires84529681vires
wires86034911wires
aces67645092aces
acres76327762acres
ages55844592ages
aides65336602aides
aired66032922aired
airer54927892airer
airers64922312airers
airest63825262airest
airns55521032airns
airs46447422air_s
airts55626342airts
ales47067102ales
anes45255932anes
apes66047432apes
apres75426402apres
arbs66834732arbs
arcs67834782arcs
are37874572are_
area45843392area
areas55935772areas
arfs76029962arfs
arks85936872arks
arles56735742arles
arms66137492arms
ars37670932ar_s
arse46539272arse
arses55733872arses
arts49650262arts
ates45047922ates
aures55137092aures
aves76142602aves
awes76037552awes
axes117337852axes
ayes76543512ayes
bares75457132bares
bees65453382bees
bes56557432_bes
bices95029962bices
bides85536772bides
biers76225222biers
bikes117529472bikes
biles75542142biles
bines76946792bines
birds85421332birds
birks114920302birks
birles84920642birles
birls74023162birls
biros75325132biros
birrs74917102birrs
birse74517402birse
birses84717732birses
bises75435622bises
bites75641172bites
bizes165923662bizes
bores76448252bores
braes75735052braes
bras65746452bras
bred75130972bred
bree67241262bree
brees75632552brees
bren65629562bren
brens75823362brens
brew95023562brew
brews105617072brews
bries74942152bries
bris65539612bris
bros65635662bros
byes95230532byes
byres104421382byres
cares77369182cares
cees65941592cees
ceres75540012ceres
cines75239682cines
cire65836372cire_
cites74435592cites
cores76361852cores
cred76530882cred
creds85418772creds
cress75022832cress
crest74632692crest
crew96122682crew
crews105917502crews
cries75438402cries
cris66233432cris
crus65828482crus
cues65438982cues
cures75645432cures
dares66146702dares
dees56356632dees
dices86434242dices
dies55653522dies
dikes105831332dikes
dimes85833042dimes
dines66449152dines
dire56644142dire_
direr64927072direr
direst75024242direst
dirges84915102dirges
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dites66339152dites
dives95832402dives
does56554472does
dree56638322dree
drees65628522drees
dreg66821652dreg
dregs76114862dregs
drek96321092drek
dreks105714752dreks
dress65319832dress
drest65530342drest
drew86221672drew
dries64733672dries
drys86314802drys
dues56045502dues
dures65635922dures
dyes85331892dyes
ekes86726602ekes
emes65434662emes
eras45441502eras
ere36352772ere_
ergs55523812ergs
ernes55224812ernes
erns45428232erns
eros45238452eros
errs45622532errs
ers36046282er_s
erses55826802erses
es29048222__es
eses45336102eses
eves76230462eves
ewes76328702ewes
exes116530812exes
eyes75837882eyes
eyres84921772eyres
fares85852872fares
fees76450602fees
feres86038182feres
fes66551672_fes
fibres114312122fibres
fices106031162fices
fifes114822392fifes
files85441272files
fines86644262fines
fire76245592fire_
fired94829742fired
firer811229252firer
firers94922682firers
firms105217422firms
firns86018542firns
firs76637712fir_s
fives116027362fives
fixes154723592fixes
foes76543442foes
fores85847102fores
free75940182free
frees86131392frees
fresh115012202fresh
fret75845042fret
frets85523402frets
fries85535602fries
froes86126692froes
gaes56348032gaes
gees55647882gees
gibes84422522gibes
gies55641422gies
girds74816992girds
girls64518392girls
girns64516802girns
giros65722652giros
girts65423622girts
gites65630182gites
gives95324872gives
goes55644092goes
gores65740372gores
gree56641562gree
grees65132472grees
grew85620262grew
grey85624042grey
greys96614852greys
grues65721962grues
gyres94820322gyres
haes77651022haes
hares86255542hares
heres86245902heres
hers75844872hers
hes66654202_hes
hides95129422hides
hies74842832hies
hikes125426982hikes
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirees95117292hirees
hirer85423122hirer
hirers94518062hirers
hives116925512hives
hoes75755732hoes
hues75235232hues
ibex133813482ibex
ibis66519582ibis
ice56737242ice_
iced78721892iced
ichs96214712ichs
idea59122772idea
ideas65919012ideas
idem76121062idem
idles66720122idles
ids47535472i_ds
ifs67124242i_fs
iggs66612672iggs
ilea45931462ilea
ileus54616892ileus
ilex115822032ilex
ilks87218572ilks
ills47030422ills
imps86221122imps
inks86926502inks
inns46920932inns
ins35945602i_ns
inures63318952inures
ions46737852ions
irades74517392irades
irid55927172irid
irides74519122irides
irids66417772irids
irises64221172irises
irk76426362ir_k
irked104510922irked
iron46728462iron
irones64724012irones
irons55324132irons
is27048212i__s
isles54220562isles
isms66213472isms
item65620382item
items7499612items
its35538832i_ts
ivies84215762ivies
iwis77117012iwis
jees115938542jees
jibes145520322jibes
jives154820812jives
joes116635892joes
kaes85734062kaes
kibes115521112kibes
kiers95320092kiers
kikes85122552kikes
kines95039132kines
kirks84915262kirks
kirns95315452kirns
kirs85831742kir_s
kites95432542kites
kris86423602kris
kues86426772kues
kyes115124932kyes
lares54852632lares
lees45455882lees
les35663072_les
liers55130402liers
lies46454192lies
likes96231902likes
limes75636502limes
lines57054572lines
liras56021982liras
lire47845292lire_
litres65220392litres
lives86133192lives
livres94311862livres
lores55045402lores
lues45943552lues
lures56138532lures
lyes75530832lyes
lyres85019962lyres
maes66948402maes
mares76457632mares
meres75143572meres
mikes115129892mikes
miles74645072miles
mimes95732022mimes
mines75651952mines
mire66748232mire_
mired85729222mired
mirex146816622mirex
mirks115122142mirks
mirs66940572mir_s
mises74740562mises
mites75141802mites
mitres83922072mitres
mixes147224402mixes
moires8915632moires
mores76249642mores
mures75937222mures
nares55544152nares
nides65229132nides
nines55937342nines
nites55736342nites
nitres65519332nitres
nixes124519622nixes
noes45845392noes
obes66036832obes
odes57243242odes
oes35866192_oes
ogres65818632ogres
okes84936342okes
oles46453472oles
ones46146532ones
opes65942612opes
orbs66626252orbs
orcs67025432orcs
ore36661832ore_
orles55326212orles
ors35750112or_s
orts46538332orts
oses46641512oses
owes75137102owes
oxes116530722oxes
oyes74940132oyes
pares77164482pares
pees65257372pees
peres76246642peres
pes57259782_pes
piers75926332piers
pies66949602pies
pikes115031032pikes
piles74742612piles
pines76048862pines
pipes96030142pipes
pirns76020092pirns
pixes144323172pixes
pores75849032pores
pree67044732pree
prees75937172prees
prep86427672prep
preps96220692preps
presa74319042presa
prese75228382prese
press75425952press
prest75736352prest
prex135722972prex
prey96228482prey
preys105717782preys
prez156126312prez
pries74339532pries
pros65742782pros
pyes95528992pyes
pyres105523882pyres
quires154015752quires
rares55247442rares
ras37575392_ras
re26153742_re_
reb55844962_reb
rebs65733562_rebs
rec55645462_rec
recs65734182_recs
red46755802_red
reds56042862_reds
ree37974072_ree
rees45364192rees
ref66053292_ref
refs75732242_refs
reg46146492_reg
regs55436572_regs
rei35647252_rei
reis45343232_reis
rem56150042_rem
rems66237722_rems
rep55847802_rep
reps65937952_reps
resh76523452_resh
rest46459842_rest
ret35982832_ret
rets45352562_rets
rev65336622_rev
revs75027052_revs
rex105740992_rex
rias45540592rias
ribes75530172ribes
ribs65833022ribs
rices75536152rices
rides66140812rides
rids56539552rids
riel46432382riel
riels55121332riels
rifs74929002rifs
rigs55137592rigs
riles55343642riles
rimes75634542rimes
rims65936302rims
rins46153192rins
ripes75435772ripes
rips66237432rips
rise45945232rise
rises55244042rises
rites54442552rites
rives85336002rives
roes45954142roes
rues46044482rues
ryes75529352ryes
sees45361052sees
seres55448892seres
sers45746652sers
shes75734352shes
shires95225572shires
sices75637272sices
sides65838362sides
sikes96236082sikes
sines55954822sines
sipes76036952sipes
sire46150412sire_
sired66134282sired
siree55238812siree
sirees64624582sirees
siren54525822siren
sirens65318152sirens
sirs44338332sir_s
sises55233832sises
sites56045432sites
sixes124526362sixes
sizes146727762sizes
sores55454282sores
spires84628112spires
sris45434152sris
sues46247652sues
tares57456562tares
tees45353582tees
tides64830152tides
tiers55526522tiers
ties45248312ties
tikes95628902tikes
tiles55542102tiles
times75630822times
tines54848422tines
tire46143352tire_
tired65228902tired
tirls54519802tirls
tiros54524892tiros
titres64718932titres
toes46956442toes
tores55352672tores
tree47745812tree
trees55835762trees
tref77030992tref
trek86222312trek
treks96016852treks
tress55423162tress
tret46653532tret
trets55928022trets
trews86118892trews
trey77228792trey
treys85018212treys
tries55742812tries
trues54925322trues
tyes76433372tyes
tyres84725232tyres
ukes86122812ukes
urbs65922062urbs
urds55922432urds
urea46528062urea
ureas55826012ureas
urges64619912urges
urns46323902urns
urps66920482urps
urus46426142urus
uses44931112uses
utes45930882utes
vees75439432vees
vibes104719952vibes
vices105725532vices
viers85621952viers
vies75238622vies
vines85137642vines
vireo84816452vireo
vireos94212452vireos
virls85618602virls
virus85316842virus
vises84427772vises
voes75432822voes
waes76048602waes
wares88250582wares
wees76249122wees
wides94832822wides
wifes114522562wifes
wiles85437872wiles
wines85546862wines
wipes104827082wipes
wire75839812wire_
wired95327642wired
wirer85124952wirer
wirers94617892wirers
wises85633192wises
wites85536962wites
wives115328922wives
wizes174723342wizes
woes76440662woes
wren78221682wren
wrens85016242wrens
wrest84925432wrest
wries85827742wries
wyes105727502wyes
yes66250612_yes
yikes125117752yikes
yipes106017842yipes
yirds96612512yirds
yirrs8469192yirrs
yores85031322yores
zaires1539702zaires
zees136331892zees
zines145232652zines

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.280638182.1
2DLD Change Limit298725290.76339150.7
3Display Results5295290.1433699.3
 (SQL Overall)1786915291.186150666.9
 
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.