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

333 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
bier6553182(None) 
beer65635991beer
bider85728371bider
biers76225221biers
biker116022561biker
biner75930691biner
birr66022351birr
biter75030031biter
brier74527401brier
kier86526801kier
lier45942461lier
pier66035291pier
tier44936141tier
vier75428151vier
abider95314462abider
abler75624312abler
ager55935842ager
aider65431132aider
aimer75926822aimer
air38058392ai_r
airer54927892airer
aiver85725162aiver
aper66336232aper
aver75931882aver
babier103515562babier
bailer85425252bailer
baiter84422552baiter
baker115629542baker
baler75635272baler
bar58070552b_ar
bare65460522bare
barer74535802barer
baser74828922baser
be47948942b_e_
bear66844642bear
bed67950622b_ed
bee56262402b_ee
beef96233672beef
been65335782been
beep85931212beep
beers75628392beers
beery105220122beery
bees65453382bees
beet66457542beet
beg65944132b_eg
bel57148462b_el
belier84423562belier
ben56554922b_en
berg75425542b_erg
berk105929842b_erk
berm86732752b_erm
bes56557432b_es
bet58376672b_et
bey86645422b_ey
bi48046462bi__
bias64738152bias
bib77045922bi_b
bibb75819192bibb
bibber94613572bibber
bibs84830972bibs
bice86235552bice
bicep115413542bicep
bices95029962bices
bicker144819172bicker
bid67751782bi_d
bidder104114862bidder
bide76041472bide
bided95424962bided
biders94822802biders
bides85536772bides
bidet84935622bidet
bidi78226562bidi
bids75838422bids
bield84614652bield
biff125026872biff
big67345712bi_g
bigger104315062bigger
bigs76235012bigs
bike106532592bike
biked125320032biked
bikers124517552bikers
bikes117529472bikes
bile66147172bile
biles75542142biles
bilk105824412bilk
bilker124913442bilker
bill67239932bill
biller84923482biller
bima86723822bima
bin56658632bi_n
bind76234502bind
binder94422872binder
bine66650852bine
biners85023632biners
bines76946792bines
binger94923442binger
bins66548242bins
bint67355032bint
bio57846072bi_o
biog76122312biog
bios66335312bios
biped104718832biped
bird76128312bird
birder94915492birder
birk106326852birk
birl65830462birl
birler85715082birler
biro66131202biro
birrs74917102birrs
bis56860652bi_s
bise66437092bise
bises75435622bises
bisk106523342bisk
bister84922762bister
bit57070892bi_t
bite66546992bite
biters83925232biters
bites75641172bites
bits66148152bits
bitt65545802bitt
bitter84622672bitter
biz147939352bi_z
bize155926282bize
bizes165923662bizes
blear75918682blear
bleb85425222bleb
bled75729312bled
blet66247672blet
blew94722432blew
bluer74918492bluer
blur66020532blur
boar66134292boar
boiler84319272boiler
boner75133082boner
bonier84321992bonier
boor66130682boor
bore66051332bore
borer75131272borer
bower107328182bower
boxer145016522boxer
boxier154311742boxier
bred75130972bred
bree67241262bree
bren65629562bren
brew95023562brew
briar75718152briar
briber104714042briber
brie65837902brie_
brief105422592brief
briers85319732briers
briery114510772briery
bries74942152bries
briner84519042briner
brr56921922b_rr
brrr65312292brrr
buhr95315382buhr
bur55744692b_ur
burier84324652burier
burr65631232burr
busier85219722busier
buyer105013092buyer
bye86134592bye_
byes95230532byes
byre95023852byre
cider84723312cider
cire65836372cire
citer74827322citer
crier74724462crier
deer56739022deer
dicer85426422dicer
die46759652die_
died66137852died
diel59034602diel
dies55653522dies
diet57357532diet
diker105524552diker
dimer85625602dimer
diner65632902diner
dire56644142dire
direr64927072direr
diver94827802diver
doer57734702doer
drier64423962drier
dyer85522112dyer
eger55923562eger
eider64624742eider
er28345142__er
ever77027692ever
ewer77523982ewer
eyer76127282eyer
fer66646122_fer
fiar76427332fiar
fiber104921132fiber
fie67152442fie_
fief107331352fief
fiery114714792fiery
fifer115519972fifer
filer85433002filer
finer85431562finer
fir66744892fi_r
fire76245592fire
firer811229252firer
fiver116024942fiver
fixer154717832fixer
flier86023402flier
frier85225842frier
giber85417702giber
gie47149542gie_
gied64631982gied
gien56330022gien
gies55641422gies
giver94921202giver
goer56827102goer
heir77523802heir
her66547812_her
hider95024082hider
hie67652702hie_
hied85434042hied
hies74842832hies
hiker125119392hiker
hire75538962hire
hirer85423122hirer
hoer76533982hoer
ibex133813472ibex
icier74313742icier
ire36943172_ire
jeer115426462jeer
jiber145115702jiber
jiver155119052jiver
keir86217872keir
kief117128392kief
kiers95320092kiers
kir76535672ki_r
kiter95523212kiter
leer46239352leer
liar47229682liar
liber74723612liber
lie38264522lie_
lied55838092lied
lief76036982lief
lien45339802lien
liers55130402liers
lies46454192lies
lieu46534362lieu
lifer85822152lifer
liger65024462liger
liker95627062liker
liner55938912liner
lire47845292lire
liter54736342liter
liver85132962liver
mien65028352mien
miler75733062miler
mimer94825762mimer
miner76933542miner
mir57046762mi_r
mire66748222mire
miser75430402miser
miter75734792miter
mixer145017642mixer
nicer74618292nicer
niter55028972niter
oiler54628282oiler
omer67028392omer
orbier839982orbier
osier53518012osier
over77227342over
oyer75927652oyer
peer66238352peer
per56353092_per
pie55457402pie_
pied75035362pied
piers75926332piers
pies66949602pies
piker115622842piker
piper96523192piper
plier75221282plier
prier75027762prier
ribier84414222ribier
ricer74726612ricer
rider65231302rider
riel46432382riel
rifer84721982rifer
rimer75429242rimer
riper74328402riper
riser55431052riser
river85731692river
rubier84814732rubier
ruer46127562ruer
seer45547042seer
ser36752402_ser
shier85428942shier
sieur5911892sieur
siker95326032siker
sir35746672si_r
sire46150412sire
siver85728612siver
sizer145521812sizer
skier95119592skier
slier54827242slier
spier75728032spier
suer45334032suer
tie36557532tie_
tied55535212tied
tiers55526522tiers
ties45248312ties
tiger65718632tiger
tiler56131022tiler
timer75626042timer
tire46143352tire
titer55430612titer
trier54328532trier
twier84713292twier
tyer75323392tyer
user45023002user
veer76229572veer
vie65447632vie_
vied86328632vied
viers85621952viers
vies75238622vies
view105917672view
viler86324162viler
viper105017302viper
weer75535092weer
weir76019922weir
wider94826352wider
wiper105421292wiper
wire75839812wire
wirer85124952wirer
wiser85522802wiser
wiver115924512wiver
wrier84521752wrier
yirr76513572yirr

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.0961861364.6
2DLD Change Limit298723331.17025531.6
3Display Results3333330.0933580.6
 (SQL Overall)1786913331.359131487.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.