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

239 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
wirer8512495(None) 
airer54927891airer
direr64927071direr
firer811229251firer
hirer85423121hirer
wider94826351wider
wiper105421291wiper
wire75839811wire_
wired95327641wired
wirers94617891wirers
wires86034911wires
wirier94215551wirier
wiser85522801wiser
wiver115924511wiver
wrier84521751wrier
aider65431132aider
aimer75926822aimer
aired66032922aired
airers64922312airers
airier64619362airier
aiver85725162aiver
barer74535802barer
bider85728372bider
bier65531832bi_er
biker116022562biker
biner75930692biner
birder94915492birder
birler85715082birler
birr66022362bir_r
biter75030032biter
borer75131272borer
brier74527402brier
carer74942332carer
cider84723312cider
cire65836372cire_
cires74932912cires
citer74827332citer
corer75538872corer
crier74724462crier
curer75030752curer
darer65230792darer
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire_
diver94827802diver
drier64423962drier
eider64624742eider
fairer95212062fairer
farer86733142farer
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finer85431562finer
fire76245592fire_
fired94829742fired
firers94922682firers
fires85740752fires
firmer114712442firmer
fiver116024942fiver
fixer154717832fixer
frier85225842frier
giber85417702giber
girder84312062girder
giver94921202giver
hider95024082hider
hiker125119392hiker
hire75538962hire_
hired95226262hired
hiree85427802hiree
hirers94518062hirers
hires86134342hires
ire36943172_ire_
ired55131872_ired
ires45639282_ires
jiber145115702jiber
jiver155119052jiver
kier86526802ki_er
kiter95523212kiter
liber74723622liber
lier45942462li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
lire47845292lire_
liter54736342liter
liver85132962liver
lurer54625312lurer
merer75126232merer
miler75733062miler
mimer94825762mimer
miner76933542miner
mire66748232mire_
mired85729222mired
mires75640882mires
mirex146816622mirex
mirier83918362mirier
mirker123712692mirker
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
niter55028972niter
oiler54628282oiler
parer75839902parer
pier66035292pi_er
piker115622842piker
piper96523192piper
prier75027762prier
purer75127902purer
rarer54731702rarer
ricer74726612ricer
rider65231302rider
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
serer55935512serer
siker95326032siker
sire46150412sire_
sired66134282sired
siree55238812siree
siren54525822siren
sires55945372sires
siver85728612siver
sizer145521812sizer
sorer56236592sorer
surer54833102surer
tier44936142ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire_
tired65228902tired
tires55437492tires
titer55430612titer
trier54328532trier
twier84713292twi_er
twiner94012592twiner
twirler10285202twirler
vier75428152vi_er
viler86324162viler
viper105017302viper
vireo84816452vireo
vires84529682vires
wader95325362wader
wafer114417642wafer
wager95925052wager
wailer93720322wailer
waired106015832waired
waiter94321252waiter
waiver124212712waiver
waker125526592waker
waler84229262waler
warder104020272warder
ware76254722ware_
wared96339872wared
wares88250582wares
warier93722892warier
warmer113816732warmer
warner93717222warner
warper114015582warper
water84733312water
waver115025702waver
waxer154317482waxer
wearer94319402wearer
weber10313522weber
weer75535092w_eer
weiner94214132weiner
weirder1144922weirder
were76238332were_
whiner124516632whiner
whirler13307602whirler
whirr114611192whir_r
whiter124316392whiter
wicker154518672wicker
widder112913972widder
wide85235402wide_
widen94717972widen
wides94832822wides
wiener94513542wiener
wife105228022wife_
wifed125117742wifed
wifes114522562wifes
wifey144913672wifey
wilder103616472wilder
wile75944372wile_
wiled95231552wiled
wiles85437872wiles
wilier93217072wilier
willer94021062willer
wincer115018192wincer
winder104025262winder
wine74953422wine_
wined94434182wined
winery125014282winery
wines85546862wines
winey115325432winey
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wipe94830282wipe_
wiped114722082wiped
wipers115416082wipers
wipes104827082wipes
wirra83210822wirra
wiry106422832wir_y
wise75737342wise_
wised95123342wised
wises85633192wises
wisher123617062wisher
wite75443272wite_
wited94727142wited
wites85536962wites
wither124321352wither
wive105931752wive_
wived125121502wived
wivern12409282wivern
wivers125320802wivers
wives115328922wives
wizen175813862wizen
wizes174723342wizes
wooer84316692wooer
wore77144672wore_
worker134715112worker
wormer114514912wormer
worser95117522worser
wren78221682w_ren
wried95518562wried
wries85827742wries
writer94416512writer
wryer11489302wryer
yarer84321572yarer
yirr76513572yir_r

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 Filter178691538000.310576422.6
2DLD Change Limit538002391.44037361.1
3Display Results2392390.0603983.3
 (SQL Overall)1786912391.81098724.3
 
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.