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

164 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
bicarbs133601(None) 
bicarb1238541bicarb_
barbs95928192b__arbs
bicorns11338762bicorns
carbs96031462__carbs
picaras11311282picaras
picaros11310892picaros
vicars11712262vicar_s
acarus8312193_acarus
aldicarbs1442023aldicarbs
arbs66834733___arbs
ascaris93613323ascaris
baccaras1446913baccaras
barb85240063b__arb_
barbe95328283b__arbe
barbes104526233b__arbes
bards87139643b__ards
bares75457133b__ares
barfs104826003b__arfs
barks115735813b__arks
barms96128463b__arms
barns76335143b__arns
bars66564093b__ar_s
bayards13379683bayards
bazars174613113bazar_s
beards94116673b_eards
bears75739043b_ear_s
becalms1335743becalms
becaps123811403beca_ps
becharms1745343becharms
bedaubs1233693bedaubs
bewares12313373bewares
bialis83617163bi_alis
bialys11387913bi_alys
bias64738163bi_a__s
biases84618433bi_ases
bibbs84911583bi__bbs
bibs84830993bi___bs
biceps12447713bic_eps
bices95029963bic__es
bickers154316553bickers
bicorn103610103bicor_n
bicorne11297553bicorne
bicornes12307253bicornes
bicron103710773bic_ron
bicrons113410473bicrons
bidarka1443843bidarka
bidarkas1543363bidarkas
biders94822803bider_s
biers76225223bi_er_s
bifaces1448063bifaces
bikers124517553biker_s
bimahs13508303bima_hs
bimas95521743bima__s
binaries10314183binaries
binarism1248353binarism
binary11312223binar_y
biners85023633biner_s
bipacks1745043bipacks
biparous1246923biparous
biparty1445583biparty
birds85421333bi__rds
birks114920303bi__rks
birls74023163bi__rls
biros75325133bi__ros
birrs74917103bi__rrs
bistres94017213bistres
bistros92810983bistros
biters83925243biter_s
bizarre1844103bizarre
bizarres1953793bizarres
bizarro1843333bizarro
bizarros1942713bizarros
blabs95619633b_la_bs
blares85021633b_lares
blears85116453blear_s
blurbs10489313b_lurbs
boards94616933b_oards
boars75229603b_oar_s
boarts84716873b_oarts
bogarts1047743bogarts
boxcars1834773boxcar_s
boyards13399323boyards
boyars115611983boyar_s
briards10398553briards
briars84814823briar_s
buckras1537343buckras
burbs95423493b__urbs
cabs86739423__ca_bs
carb85143163__carb_
carbo94923843__carbo
carbos105122263__carbos
cards85137933__cards
cares77369183__cares
carks115534213__carks
carls77037423__carls
carns75937563__carns
carobs104818103__carobs
carps96932253__carps
carrs75730853__carrs
cars67364763__car_s
carts78946293__carts
cicadas1235993cicadas
cicalas1139303cicalas
ciceros1158583ciceros
cigars9910723cigar_s
crabs95421393__crabs
curbs94821653__curbs
darbs85323263__darbs
decares102818533decares
dicamba1453413dicamba
dicambas1553793dicambas
dicasts1078703dicasts
dicers94720743dicer_s
dinars75417563dinar_s
disarms1039043disarms
discards1238913discards
epicarps1444783epicarps
escarps11397373escarps
escars83913133escar_s
fiacres1237253fiacres
fiars86720833fi_ar_s
garbs86321413__garbs
hijabs1833083hija_bs
iambs95815063_i_ambs
inarms8410093_inarms
izars145112933_izar_s
jicamas1845053jicamas
kinaras1159123kinaras
liards75212613li_ards
liars54723163li_ar_s
lidars7310783lidar_s
lizards17427613lizards
micas96823053mica__s
micros104115363mic_ros
mihrabs1444203mihrabs
nicads938333nica_ds
oxcarts1634313oxcarts
picara10311903picar_a
picaro10311323picar_o
picas94626523pica__s
ricers84120993ricer_s
ricracs1136363ricracs
ritards8439943ritards
scabs94818643_sca_bs
scarabs1137293_scarabs
scares85033003_scares
scarfs114714683_scarfs
scarps104718603_scarps
scars75433533_scar_s
scarts85321493_scarts
simars84916933simar_s
sitars65417593sitar_s
sizars154812623sizar_s
tiaras6314553ti_aras
ticals83214713tica_ls
tipcarts1244573tipcarts
uncurbs1134913uncurbs
vicar10513863vicar__
vicarly1536463vicarly
visards11328153visards
vizards20377263vizards
vocabs13336313voca_bs
wizards20326403wizards

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit1340271646.00022337.8
3Display Results1641640.0463565.2
 (SQL Overall)1786911646.43627764.3
 
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.