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

261 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
wider9482636(None) 
aider65431141aider
bider85728381bider
cider84723321cider
eider64624751eider
hider95024091hider
rider65231311rider
wader95325371wader
widder112913971widder
wide85235421wide_
widen94717981widen
wides94832831wides
wilder103616471wilder
winder104025261winder
wiper105421291wiper
wirer85124951wirer
wiser85522801wiser
wiver115924511wiver
abider95314462abider
adder75419592adder
aide56045012aide_
aided75828942aided
aiders74524632aiders
aides65336612aides
aimer75926822aimer
airer54927892airer
aiver85725162aiver
alder65421912alder
arider74717742arider
bidder104114862bidder
bide76041512bide_
bided95424972bided
biders94822802biders
bides85536782bides
bidet84935632bidet
bier65531842bi_er
biker116022562biker
binder94422872binder
biner75930692biner
birder94915492birder
biter75030032biter
ceder85322242ceder
chider125116052chider
ciders94620092ciders
cinder94119122cinder
citer74827332citer
coder86134222coder
cyder114611132cyder
dicer85426422dicer
diker105524552diker
dimer85625602dimer
diner65632902diner
direr64927072direr
diver94827802diver
eide55832252eide_
eiders74321362eiders
elder64020022elder
ender64325862ender
fader94421512fader
fiber104921132fiber
fifer115519972fifer
filer85433002filer
finder104020232finder
finer85431562finer
firer811229252firer
fiver116024942fiver
fixer154717832fixer
giber85417702giber
gilder84415532gilder
girder84312062girder
giver94921202giver
glider84614262glider
guider84313522guider
heder95623642heder
hide85134652hide_
hided105222452hided
hiders104919652hiders
hides95129432hides
hiker125119392hiker
hinder104120062hinder
hirer85423122hirer
idea59122782_idea
idem76121072_idem
ides57734242_ides
idler65015662_idler
jiber145115702jiber
jiver155119052jiver
kidder123811112kidder
kier86526822ki_er
kinder113716852kinder
kiter95523222kiter
lader65633722lader
liber74723622liber
lidar6312732lidar
lieder74912322lieder
lier45942472li_er
lifer85822152lifer
liger65024472liger
liker95627062liker
liner55938922liner
liter54736342liter
liver85132962liver
milder93818452milder
miler75733062miler
mimer94825762mimer
minder94822502minder
miner76933542miner
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
nide55535802nide_
nided75920882nided
nides65229142nides
niter55028972niter
nuder66416832nuder
odder74515392odder
oiler54628282oiler
older65121172older
order65019362order
pier66035302pi_er
piker115622842piker
pinder94523462pinder
piper96523192piper
raider74318742raider
ricer74726612ricer
ridder84015142ridder
ride55945142ride_
riders74123902riders
rides66140822rides
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
ruder65320542ruder
seder64826762seder
side55444502side_
sided74825962sided
sides65838372sides
sidler74716962sidler
siker95326032siker
siver85728612siver
sizer145521812sizer
slider73918362slider
snider74413912snider
spider94516802spider
tide55237392tide_
tided76322522tided
tides64830162tides
tidier73515112tidier
tier44936152ti_er
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tinder73821802tinder
titer55430612titer
twier84713292twi_er
twiner94012592twiner
udder76314282udder
under64624222under
vide85432772vide_
video96014962video
vier75428162vi_er
viler86324162viler
viper105017302viper
voider103611552voider
wadder114215482wadder
wade85237072wade_
waded106024752waded
waders109120652waders
wades95634142wades
wafer114417652wafer
wager95925062wager
wailer93720332wailer
waiter94321252waiter
waiver124212712waiver
waker125526602waker
waler84229292waler
wander104423712wander
warder104020272warder
water84733322water
waver115025712waver
waxer154317492waxer
weber10313522weber
wedder113612302wedder
wedel94513962wedel
weeder103315512weeder
weer75535092w_eer
weiner94214132weiner
weirder1144922weirder
welder102914412welder
whiner124516632whiner
whiter124316392whiter
wicker154518672wicker
widders123512272widders
widdy136112192widdy
widely133311032widely
widener11318692widener
widens106212722widens
widest104517002widest
widget113815262widget
widow1278942widow
widower1435342widower
width12310972width
wielder11197672wielder
wiener94513542wiener
wife105228032wife_
wifed125117742wifed
wifes114522562wifes
wifey144913672wifey
wilded113714502wilded
wilders113513502wilders
wile75944382wile_
wiled95231552wiled
wiles85437872wiles
wilier93217072wilier
willer94021062willer
wincer115018192wincer
winded114918212winded
winders113721262winders
windier113412162windier
wine74953432wine_
wined94434182wined
winery125014282winery
wines85546862wines
winey115325432winey
winger104125442winger
winier94522452winier
winker134220292winker
winner94219932winner
winter94222802winter
wipe94830292wipe_
wiped114722082wiped
wipers115416082wipers
wipes104827082wipes
wire75839822wire_
wired95327642wired
wirers94617892wirers
wires86034912wires
wirier94215552wirier
wise75737352wise_
wised95123342wised
wises85633192wises
wisher123617062wisher
wite75443282wite_
wited94727142wited
wites85536962wites
wither124321352wither
wive105931762wive_
wived125121502wived
wivern12409282wivern
wivers125320802wivers
wives115328922wives
wizen175813862wizen
wizes174723342wizes
wonder103617812wonder
wooer84316692wooer
wrier84521752wrier
writer94416512writer
wryer11489302wryer

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.330541487.9
2DLD Change Limit538002611.50035866.7
3Display Results2612610.0763434.2
 (SQL Overall)1786912611.90693751.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.