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
bib7704594(None) 
bi48046471bi_
bibb75819211bibb
bibs84830991bibs
bid67751791bid
big67345721big
bin56658641bin
bio57846081bio
bis56860661bis
bit57070901bit
biz147939361biz
bob76755671bob
bub76343981bub
dib65746941dib
fib86344271fib
gib66443531gib
jib125835971jib
lib57750271lib
mib76946121mib
nib56745191nib
rib56848031rib
sib56850311sib
ab410674762_ab
ai211288392ai_
aid49269072aid
ail37171042ail
aim57858212aim
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
alb57342652alb
arb510448422arb
ba49962342b_a
baa510650422baa
baba88828352baba
babe86835822babe
babu85829232babu
baby116723682baby
bad67763152bad
bag67059222bag
bah87755352bah
bail65042802bail
bait66556002bait
bal56662722bal
bam78560142bam
ban58366832ban
bap76455842bap
bar58070552bar
barb85240062barb
bas58681752bas
bat510988952bat
bay89661642bay
be47948942b_e
bed67950622bed
bee56262402bee
beg65944132beg
bel57148462bel
ben56554922ben
bes56557432bes
bet58376672bet
bey86645422bey
bias64738162bias
bibbs84911582bibbs
bible95119422bible
bice86235562bice
bide76041482bide
bidi78226572bidi
bids75838432bids
bier65531832bier
biff125026892biff
bigs76235022bigs
bike106532602bike
bilbo95513612bilbo
bilby124912352bilby
bile66147182bile
bilk105824422bilk
bill67239942bill
bima86723832bima
bimbo114811872bimbo
bind76234512bind
bine66650862bine
bins66548252bins
bint67355042bint
biog76122322biog
bios66335322bios
bird76128322bird
birk106326862birk
birl65830472birl
biro66131212biro
birr66022362birr
bise66437102bise
bisk106523352bisk
bite66547002bite
bits66148162bits
bitt65545812bitt
bize155926292bize
blab86629132blab
bleb85425222bleb
blin67228172blin
blip88322772blip
blob86027092blob
blub85324872blub
bo410957572b_o
boa56954032boa
bobs86340652bobs
bod67055542bod
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
bud67041272bud
bug65340742bug
bulb85626692bulb
bum75342692bum
bun56348142bun
bur55744692bur
burb85334672burb
bus56950972bus
but55963022but
buy86436542buy
by77529232b_y
bye86134592bye
bys85229462bys
cab78355402cab
cig67036182cig
cis57748032cis
cob710258752cob
crib86323582crib
cub76940942cub
dab67455562dab
deb66342692deb
dibs76233682dibs
did56850512did
die46759652die
dif76846902dif
dig57544472dig
dim68146492dim
din46459462din
dip67848982dip
dis46459892dis
dit47071332dit
drib76823262drib
dub66642202dub
ebb72418632ebb
fab87453132fab
fibs96329502fibs
fid76847682fid
fie67152442fie
fig76242832fig
fil65447142fil
fin66458032fin
fir66744892fir
fit66365452fit
fix136236102fix
fiz156238762fiz
fob86748332fob
fub86337392fub
gab67155992gab
gibe75927782gibe
gibs75529272gibs
gid57047262gid
gie47149542gie
gig56040752gig
gin46055752gin
gip67645362gip
git46266052git
glib79421442glib
gob68950892gob
hi57947582hi_
hic86540562hic
hid76248362hid
hie67652702hie
him86247652him
hin67559562hin
hip86750432hip
his66359502his
hit66569192hit
hob87550922hob
hub86437482hub
ibis66519582ibis
id38941832_id
if57239952_if
in28150862_in
is27048212_is
it28455682_it
jab128444112jab
jibb155816742jibb
jibe136323392jibe
jibs136724082jibs
jig115633512jig
jin106443932jin
job128041772job
kab97145852kab
ki67537952ki_
kibe106523442kibe
kid86540612kid
kif105941182kif
kin76353962kin
kip97042132kip
kir76535672kir
kis78051472kis
kit78559872kit
kob99442382kob
lab58864782lab
li29948752li_
libs66732762libs
lid47453512lid
lie38264522lie
limb85429382limb
lin37967372lin
lip514755802lip
lis37162272lis
lit39377312lit
lob57154462lob
mi48249052mi_
mibs85330482mibs
mic77647642mic
mid67354462mid
mig65646082mig
mil55752112mil
mim76048422mim
mir57046772mir
mis58162622mis
mix126138182mix
mob78651922mob
nab56954922nab
neb57238622neb
nibs65028312nibs
nil36144192nil
nim57142952nim
nip56945982nip
nit37065942nit
nix106932832nix
nob58954422nob
nub56439142nub
obi57127732obi_
obia67923112obia
obis66226842obis
obit66837082obit
oi29061482oi_
oil37452052oil
orb55736862orb
pi48145362pi_
pia56848032pia
pic76046822pic
pie55457402pie
pig65744972pig
pin57066722pin
pip78051042pip
pis56362032pis
pit56471922pit
piu56639542piu
pix126437932pix
pub76037692pub
qi116526902qi_
qis126934382qis
reb55844962reb
ria36745502ria
ribs65833022ribs
rid46754622rid
rif65951562rif
rig46748122rig
rim56052272rim
rin36663182rin
rip56851302rip
rob56754302rob
rub56342822rub
sab56563202sab
si29149572si_
sibb85921422sibb
sibs65933542sibs
sic55847872sic
sim56553132sim
sin36265892sin
sip57656012sip
sir35746672sir
sis37360542sis
sit35877752sit
six105339742six
snib66522982snib
sob57857942sob
sub55445552sub
tab57460322tab
ti28448292ti_
tic56343462tic
tie36557532tie
til36350262til
tin36362172tin
tip56551222tip
tis37056642tis
tit36771042tit
tub55640032tub
urb55731102urb
via65636242via
vibe95124502vibe
vid77241802vid
vie65447632vie
vig75637522vig
vim87437022vim
vis66747612vis
wab87051832wab
web85735562web
wig76740382wig
win66456292win
wis66552332wis
wit66563772wit
wiz156434152wiz
xi98128162xi_
xis106935332xis
yid76640822yid
yin67648732yin
yip87241172yip
yob87945272yob
zig136931902zig
zin125643772zin
zip146636222zip
zit126049992zit

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.0762351197.4
2DLD Change Limit140843390.42333295.5
3Display Results3393390.0605650.0
 (SQL Overall)1786913390.559319661.9
 
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.