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

339 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
bib7704595(None) 
bi48046481bi_
bibb75819221bibb
bibs84831001bibs
bid67751821bid
big67345731big
bin56658651bin
bio57846091bio
bis56860671bis
bit57070911bit
biz147939371biz
bob76755671bob
bub76343981bub
dib65746951dib
fib86344281fib
gib66443541gib
jib125835981jib
lib57750281lib
mib76946131mib
nib56745201nib
rib56848041rib
sib56850321sib
ab410674762_ab
ai211288402ai_
aid49269092aid
ail37171052ail
aim57858222aim
ain37579102ain
air38058402air
ais39083582ais
ait38093912ait
alb57342652alb
arb510448422arb
ba49962342b_a
baa510650422baa
baba88828352baba
babe86835822babe
babu85829232babu
baby116723682baby
bad67763162bad
bag67059222bag
bah87755352bah
bail65042802bail
bait66556002bait
bal56662722bal
bam78560142bam
ban58366842ban
bap76455842bap
bar58070552bar
barb85240062barb
bas58681752bas
bat510988952bat
bay89661642bay
be47948942b_e
bed67950632bed
bee56262402bee
beg65944132beg
bel57148462bel
ben56554922ben
bes56557432bes
bet58376672bet
bey86645422bey
bias64738172bias
bibbs84911582bibbs
bible95119422bible
bice86235572bice
bide76041512bide
bidi78226602bidi
bids75838462bids
bier65531842bier
biff125026902biff
bigs76235032bigs
bike106532612bike
bilbo95513612bilbo
bilby124912352bilby
bile66147192bile
bilk105824432bilk
bill67239952bill
bima86723842bima
bimbo114811872bimbo
bind76234522bind
bine66650872bine
bins66548262bins
bint67355052bint
biog76122332biog
bios66335332bios
bird76128332bird
birk106326872birk
birl65830482birl
biro66131222biro
birr66022372birr
bise66437112bise
bisk106523362bisk
bite66547012bite
bits66148172bits
bitt65545822bitt
bize155926302bize
blab86629132blab
bleb85425222bleb
blin67228172blin
blip88322772blip
blob86027092blob
blub85324872blub
bo410957572b_o
boa56954032boa
bobs86340652bobs
bod67055552bod
bog67852412bog
boil66335182boil
bomb106927422bomb
boo58163662boo
boob85932582boob
bop77549482bop
bos57966812bos
bot59680402bot
bow87051902bow
box1210142342box
boy87753562boy
bra56339462bra
bribe94820782bribe
brie65837902brie
brig76528032brig
brim85629372brim
brin67038192brin
brio65432492brio
bris65539612bris
brit66350152brit
bro56236602bro
brr56921922brr
bubo85621912bubo
bubs86235502bubs
bubu85022672bubu
bud67041282bud
bug65340742bug
bulb85626692bulb
bum75342692bum
bun56348142bun
bur55744692bur
burb85334672burb
bus56950972bus
but55963022but
buy86436542buy
by77529232b_y
bye86134592bye
bys85229462bys
cab78355402cab
cig67036192cig
cis57748042cis
cob710258752cob
crib86323582crib
cub76940942cub
dab67455562dab
deb66342692deb
dibs76233692dibs
did56850532did
die46759662die
dif76846912dif
dig57544482dig
dim68146502dim
din46459472din
dip67848992dip
dis46459902dis
dit47071342dit
drib76823262drib
dub66642202dub
ebb72418632ebb
fab87453132fab
fibs96329512fibs
fid76847702fid
fie67152452fie
fig76242842fig
fil65447152fil
fin66458042fin
fir66744902fir
fit66365462fit
fix136236112fix
fiz156238772fiz
fob86748332fob
fub86337392fub
gab67155992gab
gibe75927792gibe
gibs75529282gibs
gid57047282gid
gie47149552gie
gig56040762gig
gin46055762gin
gip67645372gip
git46266062git
glib79421442glib
gob68950892gob
hi57947592hi_
hic86540572hic
hid76248392hid
hie67652712hie
him86247672him
hin67559572hin
hip86750442hip
his66359512his
hit66569202hit
hob87550922hob
hub86437482hub
ibis66519582ibis
id38941852_id
if57239962_if
in28150872_in
is27048222_is
it28455692_it
jab128444112jab
jibb155816752jibb
jibe136323402jibe
jibs136724092jibs
jig115633522jig
jin106443942jin
job128041772job
kab97145862kab
ki67537972ki_
kibe106523462kibe
kid86540632kid
kif105941202kif
kin76353982kin
kip97042152kip
kir76535692kir
kis78051492kis
kit78559892kit
kob99442392kob
lab58864782lab
li29948762li_
libs66732772libs
lid47453532lid
lie38264532lie
limb85429392limb
lin37967382lin
lip514755812lip
lis37162282lis
lit39377322lit
lob57154462lob
mi48249062mi_
mibs85330492mibs
mic77647652mic
mid67354482mid
mig65646092mig
mil55752122mil
mim76048432mim
mir57046782mir
mis58162632mis
mix126138192mix
mob78651922mob
nab56954922nab
neb57238622neb
nibs65028322nibs
nil36144202nil
nim57142962nim
nip56945992nip
nit37065952nit
nix106932842nix
nob58954422nob
nub56439142nub
obi57127732obi_
obia67923112obia
obis66226842obis
obit66837082obit
oi29061492oi_
oil37452062oil
orb55736862orb
pi48145372pi_
pia56848042pia
pic76046832pic
pie55457412pie
pig65744982pig
pin57066732pin
pip78051052pip
pis56362042pis
pit56471932pit
piu56639552piu
pix126437942pix
pub76037692pub
qi116526912qi_
qis126934392qis
reb55844962reb
ria36745512ria
ribs65833032ribs
rid46754642rid
rif65951572rif
rig46748132rig
rim56052282rim
rin36663192rin
rip56851312rip
rob56754302rob
rub56342822rub
sab56563202sab
si29149582si_
sibb85921432sibb
sibs65933552sibs
sic55847882sic
sim56553152sim
sin36265902sin
sip57656022sip
sir35746682sir
sis37360552sis
sit35877762sit
six105339752six
snib66522982snib
sob57857942sob
sub55445552sub
tab57460322tab
ti28448302ti_
tic56343472tic
tie36557542tie
til36350272til
tin36362182tin
tip56551232tip
tis37056652tis
tit36771062tit
tub55640032tub
urb55731112urb
via65636252via
vibe95124512vibe
vid77241822vid
vie65447642vie
vig75637532vig
vim87437032vim
vis66747622vis
wab87051832wab
web85735562web
wig76740392wig
win66456302win
wis66552342wis
wit66563782wit
wiz156434162wiz
xi98128172xi_
xis106935342xis
yid76640842yid
yin67648742yin
yip87241192yip
yob87945272yob
zig136931912zig
zin125643782zin
zip146636232zip
zit126050002zit

Search took 1 second 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 Filter178691140840.250714764.0
2DLD Change Limit140843390.37637457.4
3Display Results3393390.0635381.0
 (SQL Overall)1786913390.689259348.3
 
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.