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

221 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
darbs8532326(None) 
arbs66834731_arbs
barbs95928191barbs
carbs96031461carbs
dabs77139401da_bs
darb76033531darb_
dares66146701dares
darks106727871darks
darns66927891darns
darts67635731darts
daubs85014561daubs
drabs85119671drabs
garbs86321411garbs
abs59356072_a_bs
albs68628572_albs
arb510448422_arb_
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
ars37670932_ar_s
arts49650262_arts
barb85240062barb_
barbe95328282barbe
barbes104526232barbes
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
bars66564092bar_s
burbs95423492burbs
cabs86739422ca_bs
carb85143162carb_
carbo94923842carbo
carbos105122262carbos
cards85137932cards
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carobs104818102carobs
carps96932252carps
carrs75730852carrs
cars67364762car_s
carts78946292carts
crabs95421392crabs
curbs94821652curbs
dab67455562da_b_
daces85030682daces
dadas75819862dadas
dados75522432dados
dads67442772da_ds
daffs125116422daffs
dagos76419442dagos
dags66642602da_gs
dahls95012282dahls
dahs88231812da_hs
dais57040702da_is
daks97130602da_ks
dales66439742dales
dals57145122da_ls
dames85435852dames
damns84916922damns
damps105220412damps
dams77444372da_ms
dangs75623212dangs
dans56748152da_ns
daps77239162da_ps
darbar959952darbar
darbars10510092darbars
darbies104216982darbies
dare55848862dar_e
dared75935012dared
darer65230792darer
darers75921872darers
daric85623122daric
darics94314112darics
dark95133212dar_k
darky136018832darky
darn56434622dar_n
dart55857872dar_t
dates65639152dates
datos65222782datos
daub77423442daub_
daube85015302daube
daubes94913702daubes
dauby115211222dauby
dauts67822242dauts
dawks135213492dawks
dawns95916592dawns
daws86638242da_ws
dawts97216122dawts
days87637132da_ys
dazes155024142dazes
dears65736882dear_s
debs76530242d_ebs
derby114715342derby
derms85022892derms
dibs76233682d_ibs
dirks105619522dirks
dirls64720502dirls
dirts66824462dirts
dorks105724442dorks
dorms85723842dorms
dorps85419222dorps
dorrs65520592dorrs
dors56747602dor_s
drab76226452drab_
drags75521112drags
drams86025832drams
drats66628372drats
draws95119372draws
drays95819772drays
dribs85115062dribs
drubs85913832drubs
drys86314802d_rys
dubs78432192d_ubs
dumbs105915752dumbs
duras65727732duras
dures65635922dures
durns64819872durns
duros65422692duros
durrs65519992durrs
dwarfs13436272dwarfs
earls56127512earls
earns55927562earns
ears46356592ear_s
fabs98635862fa_bs
fards96629842fards
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
forbs105720802forbs
gabs76740422ga_bs
gambs105721122gambs
garb75332672garb_
gars55750742gar_s
grabs85719692grabs
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harts88441592harts
herbs105520502herbs
iambs95815062iambs
jabs135830092ja_bs
jambs166014622jambs
jarls126120962jarls
jars117338352jar_s
kabs107130842ka_bs
karns96624142karns
karts97630112karts
kerbs115013672kerbs
labs67145122la_bs
lambs95921412lambs
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572lar_s
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
mars66261872mar_s
marts77442232marts
nabs66236192na_bs
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oar_s
orbs66626252_orbs
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792par_s
parts77743372parts
rares55247442rares
sabs66643742sa_bs
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sorbs75022102sorbs
tabs66842982ta_bs
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527122tarps
tars46763952tar_s
tarts57242022tarts
urbs65922062_urbs
varas86028192varas
vars75742072var_s
varus85921182varus
verbs104614392verbs
wabs97337232wa_bs
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802war_s
warts814840402warts
yards95324612yards
yarns85621792yarns
zarfs174713622zarfs

Search took 3 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 Filter178691538000.326548131.9
2DLD Change Limit538002211.61033416.1
3Display Results2212210.0633507.9
 (SQL Overall)1786912211.99989390.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.