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

324 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
scarabs113729(None) 
scarab10310061scarab_
carats85929022_carats
carbs96031462_car_bs
carobs104818102_carobs
crabs95421392_c_rabs
sacrals93311792sacrals
sarans64224432s_arans
scabs94818642sc__abs
scalars93711902scalars
scarers94618502scarers
scares85033002scar_es
scarfs114714682scar_fs
scarphs14437412scarphs
scarps104718602scar_ps
scars75433532scar__s
scarts85321492scar_ts
scarves124511622scarves
scrags95713802sc_rags
scrams105216622sc_rams
scraps106017242sc_raps
scrubs104210312sc_rubs
acarids105312243acarids
acarus8312193acar_us
araks94820883__araks
arbs66834733__ar_bs
ascarids11438503ascarids
ascaris93613323ascar_is
barbs95928193_bar_bs
bharals1236733bharals
bicarbs1336013bicar_bs
cabals104020153_cabals
cabobs124311883_cabobs
cabs86739423_c__abs
cacaos104616183_cacaos
cacas95627983_caca_s
camas96333523_cama_s
camass104114183_camass
canals84421663_canals
carabao1139673_carabao
carabaos1238073_carabaos
carabid12311333_carabid
carabids1338183_carabids
carabin11313213_carabin
carabins12312353_carabins
carack142113173_carack
caracks152211563_caracks
carafe115416163_carafe
carafes125015703_carafes
caramba1336893_caramba
carat75048793_cara_t
carate84734003_carate
carates95630603_carates
carb85143163_car_b_
carbo94923843_car_bo
carbos105122263_carbos
carcass11310513_carcass
cards85137933_car_ds
carers85133953_carers
cares77369183_car_es
caress85720263_caress
carets85330773_carets
cargos94619183_cargos
caribe103416743_caribe
caribes113715643_caribes
caries85147623_caries
carks115534213_car_ks
carles85435083_carles
carls77037423_car_ls
carns75937563_car_ns
carob95325223_carob_
carols85124983_carols
caroms105619573_caroms
carpals113414623_carpals
carps96932253_car_ps
carpus105514303_carpus
carrs75730853_car_rs
cars67364763_car__s
carses85233653_carses
cartes86239473_cartes
carts78946293_car_ts
carves115128453_carves
casaba1079263_casaba
casabas1139983_casabas
casas75327843_casa_s
cascaras1237693cascara_s
charas114223593chara_s
corals85325143_corals
craals84113303_craals
crab85727673_c_rab_
crags85622573_c_rags
crams96229153_c_rams
craps95328643_c_raps
crass76328043_c_rass
craws105723123_c_raws
cribs94516743_c_ribs
curbs94821653_cur_bs
darbs85323263_dar_bs
drabs85119673__drabs
ecartes94212563ecartes
escarps11397373escar_ps
escars83913133escar__s
farads104713273_farads
garbs86321413_gar_bs
grabs85719693__grabs
harass9313943_harass
kababs14409763_kababs
karats106420493_karats
maras75443283_mara_s
mascaras1237693mascara_s
mihrabs1444203mihrabs
nawabs1185063_nawabs
paras76143043_para_s
picaras11311273picara_s
sabals84618863s_abals
sabras85116363sabra_s
sabs66643743s___abs
sacra74516993sacra__
sacral83414413sacra_l
sacrums11388043sacrums
sagas66025883s_aga_s
sahibs1137073s_ahibs
salads75316963s_alads
salals65120083s_alals
samaras9312913samara_s
sambas104219263s_ambas
saran53730303s_ara_n
sarape84817573s_arape
sarapes94617743s_arapes
sardars83112903s_ardars
sards64736183s_ar_ds
sarees65329943s_arees
sarges75128593s_arges
sargos74318273s_argos
sarins63932623s_arins
saris54544953s_ar_is
sarks96632463s_ar_ks
sarods74918573s_arods
saros55238063s_ar_os
sarsars73512143s_arsars
sataras7315053satara_s
satays94411683s_atays
satraps95011643satraps
scab85926713sc__ab_
scabby1535503sca_bby
scabies11613333scabies
scabrous1245993scabrous
scads85419953sc__ads
scags85520973sc__ags
scalable121710233scalable
scalably15166703scalably
scalade10359263scalade
scalades11258803scalades
scalado10276473scalado
scalados11276083scalados
scalage103110533scalage
scalages113010253scalages
scalar83612433scala_r
scalare93311833scalare
scalares103210983scalares
scalds94813693sca_lds
scalers93817263scalers
scales84529313sca_les
scalls84218203sca_lls
scalps104315233sca_lps
scamps125014173sca_mps
scams94423973sc__ams
scandals1136993scandals
scans74625103sc__ans
scants85219723sca_nts
scapes105122263sca_pes
scar66434203scar___
scarabaei1342063scarabaei
scarabaeus1451343scarabaeus
scaraboid1443743scaraboid
scarce104013633scar_ce
scarcer113911373scarcer
scarcest12169173scarcest
scare75334463scar__e
scared95227293scar_ed
scarer84524603scar_er
scarey115016983scar_ey
scarf105427143scar__f
scarfed134711183scarfed
scarfer124511083scarfer
scarfers13408463scarfers
scarier94017873scarier
scariest101615943scariest
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scariose1037593scariose
scarious10610203scarious
scarless10189053scarless
scarlet91516943scarlet
scarlets10178573scarlets
scarp95724103scar__p
scarped124314393scarped
scarper114814823scarper
scarpers124712513scarpers
scarph13429603scar_ph
scarred104512633scarred
scarry116311183scar_ry
scart76139773scar__t
scarted104816123scarted
scary105222593scar__y
scathes124515713scathes
scats75930603sc__ats
scatts85914663sca_tts
scaups105411933sca_ups
scaurs85512043sca_urs
scenas84114703scena_s
schavs1436493sc_havs
schlubs1443193schlubs
schnaps1443703schnaps
schriks16185743schriks
schrods1337433schrods
schwas14396983schwa_s
scleras948223sclera_s
scorers94115313scorers
scores84725923scor_es
scorns85713013scor_ns
scrag85916173sc_ra_g
scram910621613sc_ra_m
scrap97120403sc_ra_p
scrape105917573sc_rape
scrapes116217663scrapes
scrawl11208083sc_rawl
scrawls12177273scrawls
screaks13469353screaks
screams114810613screams
screes85023963sc_rees
screws115513883sc_rews
scribe104613523sc_ribe
scribes113713203sc_ribes
scries85226823sc_ries
scrims104615933sc_rims
scrips105316033sc_rips
scrods94111603sc_rods
scrub94914203sc_rub_
scrums104614253sc_rums
scubas103710223scuba_s
scurfs113210813scur_fs
seabags1037483seabags
sears54744913sear__s
seawans10379943seawans
seaways13307513seaways
seracs84418573s_eracs
serais64326133s_erais
serdabs1035323serdabs
shamans123610893shamans
shamas113717933shama_s
sharable131910693sharable
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
shariahs14206393shariahs
sharias102516003sharias
sharifs13279903sharifs
sharks135019723shar_ks
sharns95516983shar_ns
sharps115516083shar_ps
shorans102812403shorans
shrubs11409213s_hrubs
sirrahs10377303sirrahs
sirras63814863sirra_s
slabs75322643s__labs
slurbs8439743slur_bs
smaragd1134393smaragd
smaragds1243303smaragds
smarms105712533smar_ms
smartass1044273smartass
smarts86218003smar_ts
snarers74216663snarers
snares65329033snar_es
snarfs95113423snar_fs
snarks104815733snar_ks
snarls64016873snar_ls
soarers74118093soarers
soars54732513soar__s
soras55041013s_ora_s
sorbs75022103s_or_bs
sovrans1036483sovrans
sparable121611973sparable
sparables13167153sparables
sparers94519613sparers
spares84834553spar_es
sparges104016333sparges
sparids103512123sparids
sparks124616363spar_ks
spars75431543spar__s
spirals93212513spirals
sprags95715823s_prags
sprats85819933s_prats
sprays115913643s_prays
squabs17429323s_quabs
stabs76221383s__tabs
stalags838643stalags
starers74522313starers
stares66038753star_es
starets73515923starets
stars55836573star__s
starts65423123star_ts
starves104614553starves
straps87721783s_traps
strass67117223s_trass
straws98718673s_traws
strays96417933s_trays
sunrays1037083sunrays
surahs94515543s_urahs
suras55336323s_ura_s
surras65919533surra_s
sutras64818583sutra_s
svaraj1634963svara_j
svarajes1843513svarajes
swabs105817273s__wabs
swaraj1636023swara_j
swarajes1843743swarajes
swards105415133swar_ds
swarfs125612063swar_fs
swarms116112163swar_ms
swarths13537323swarths
tiaras6314533tiara_s
varas86028193_vara_s

Search took 9 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.1561145455.1
2DLD Change Limit1340273248.14016465.2
3Display Results3243240.0963375.0
 (SQL Overall)1786913248.39221293.0
 
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.