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 “bicarb” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

210 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
bicarb123854(None) 
bicarbs1336011bicarbs
barb85240062b__arb
bicorn103610102bicorn
binary11312222binary
carb85143162__carb
picara10311902picara
picaro10311322picaro
vicar10513862vicar_
vicars11712262vicars
acari75020283_acari
acerb9312763_acerb
aldicarb1342903aldicarb
arb510448423___arb
baccara1347143baccara
bar58070553b__ar_
barbe95328283b__arbe
barbs95928193b__arbs
bard75648863b__ard
bare65460523b__are
barf95844413b__arf
bark106242153b__ark
barm86739603b__arm
barn66444643b__arn
bars66564093b__ars
bayard124411663bayard
bazar163816003bazar_
bazars174613113bazars
bear66844643b_ear_
beard86024963b_eard
bears75739043b_ears
becalm1239203becalm
became123213163became
becap114315053beca_p
becaps123811403becaps
becharm1636843becharm
bedaub1146033bedaub
beware11313713beware
biali73419073bi_ali
bialy105119323bi_aly
bias64738163bi_a_s
bib77045943bi___b
bibb75819213bi__bb
bice86235563bic__e
bicep115413543bic_ep
biceps12447713biceps
bices95029963bic_es
bicker144819173bicker
bickers154316553bickers
bicorne11297553bicorne
bicorns11338763bicorns
bicron103710773bicron
bidarka1443843bidarka
bider85728373bider_
biders94822803biders
bier65531833bi_er_
biers76225223bi_ers
biface1358103biface
biform1368123biform
bigamy1436343bigamy
biker116022563biker_
bikers124517553bikers
biliary1238213biliary
bima86723833bima__
bimah127013273bima_h
bimahs13508303bimahs
bimas95521743bima_s
binal75323823bina_l
binate8419773binate
biner75930693biner_
biners85023633biners
bipack1636523bipack
biparty1445583biparty
bird76128323bi__rd
birk106326863bi__rk
birl65830473bi__rl
biro66131213bi__ro
birr66022363bi__rr
birrs74917103bi_rrs
bistre83815023bistre
bistro8339943bistro
biter75030033biter_
biters83925243biters
bizarre1844103bizarre
bizarro1843333bizarro
blab86629133b_la_b
blare75826233b_lare
blear75918683blear_
blears85116453blears
bleary115112553bleary
blurb95214903b_lurb
boar66134293b_oar_
board85523003b_oard
boars75229603b_oars
boart78835933b_oart
bogart9617193bogart
bolar75123473bolar_
boxcar1734753boxcar_
boxcars1834773boxcars
boyar106013763boyar_
boyard125411283boyard
boyars115611983boyars
briar75718153briar_
briard94311293briard
briars84814823briars
briary114912003briary
buckra1436753buckra
burb85334673b__urb
cab78355403__ca_b
car59165563__car_
carbo94923843__carbo
carbs96031463__carbs
card710245873__card
care66968373__care
cark105539273__cark
carl65144783__carl
carn66245433__carn
carob95325223__carob
carp85139813__carp
carr65434703__carr
cars67364763__cars
cart66570343__cart
cicada1136413cicada
cicala10310053cicala
cicale10314503cicale
cicero1048503cicero
cigar8911803cigar_
cigars9910723cigars
crab85727673__crab
curb86732223__curb
darb76033533__darb
decare93919153decare
diary95016973di_ary
dicamba1453413dicamba
dicast9315573dicast
dicer85426423dicer_
dicers94720743dicers
dinar66319893dinar_
dinars75417563dinars
disarm9310473disarm
discard11310213discard
epicarp1376073epicarp
escar74011993escar_
escarp10449003escarp
escars83913133escars
fiacre1137623fiacre
fiar76427333fi_ar_
fiars86720833fi_ars
filar84819293filar_
garb75332673__garb
hijab1736803hija_b
hilar85418143hilar_
iamb86623733_i_amb
inarm7314423_inarm
izar136616013_izar_
izars145112933_izars
jicama1734883jicama
kinara10310373kinara
liar47229683li_ar_
liard65418593li_ard
liars54723163li_ars
lidar6312723lidar_
lidars7310783lidars
lizard16369233lizard
mica86428253mica__
micas96823053mica_s
micra96214973mic_ra
micro94715993mic_ro
mihrab1335523mihrab
nicad8312613nica_d
nicads938333nicads
nicer74618293nicer_
oxcart1539523oxcart
pica85831493pica__
pical95524373pica_l
picaras11311283picaras
picaros11310893picaros
picas94626523pica_s
pilar75221503pilar_
piscary1437423piscary
ricer74726613ricer_
ricers84120993ricers
ricrac1037013ricrac
ritard74812083ritard
scab85926713_sca_b
scar66434203_scar_
scarab10310063_scarab
scare75334463_scare
scarf105427143_scarf
scarp95724103_scarp
scars75433533_scars
scart76139773_scart
scary105222593_scary
simar74920813simar_
simars84916933simars
sitar54820543sitar_
sitars65417593sitars
sizar145214993sizar_
sizars154812623sizars
tiara5315913ti_ara
tical76021493tica_l
ticals83214713ticals
tipcart1148833tipcart
uncurb1037043uncurb
vicarly1536463vicarly
visard103910123visard
vivary1536983vivary
vizard19458853vizard
vocab12409973voca_b
wizard19377713wizard

Search took 10 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 Filter1786911127160.393454684.5
2DLD Change Limit1127162109.01312505.9
3Display Results2102100.0633333.3
 (SQL Overall)1786912109.46918871.2
 
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.