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

252 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
shofars133583(None) 
shofar1236311shofar_
sofars94712781s_ofars
hoars85925552_ho_ars
scholars1336682scholars
shears93820902sh_ears
shikars1436182shikars
shmears1277072shmears
shoals94215792sho_als
shoats94117082sho_ats
shoers94518332sho_ers
shophars1646352shophars
shorans102812412shorans
shovers134613002shovers
showers134612682showers
soars54732512s_o_ars
sofar86115492s_ofar_
sofas85320712s_ofa_s
sonars64818972s_onars
sowars94318012s_owars
afars85716513__afars
ashlars10297063ash_lars
boars75229603_bo_ars
boyars115611983_boyars
chadars1338293chadars
chafers154512743chafers
chars105936643ch__ars
chimars144010593chimars
choirs114911883cho_irs
chokers164311523chokers
cholas114818003chola_s
cholers124215203cholers
chorals124614113chorals
chufas14397673chufa_s
chukars1634283chukars
deodars937623deodars
dhooras1135943dhooras
escolars1045343escolars
gofers104711513_gofers
haars85620473_h_aars
hears86737373_h_ears
hoar76729163_ho_ar_
hoard94918313_ho_ard
hoards104912623_ho_ards
hoarse94411323_ho_arse
hoary114516763_ho_ary
hodads1147963_hodads
hoers85724923_ho_ers
hogans105914313_hogans
holard10410573_holard
holards1148433_holards
homers114821973_homers
honans94814503_honans
honers94324973_honers
honors94816793_honors
hoofers134513323hoofers
hopers114222973_hopers
horahs126313873_horahs
horary12310383_horary
horas86333103_hora_s
hosers95223963_hosers
hours85422393_ho_urs
hovers124320253_hovers
hoyas115016163_hoya_s
isobars936593isobars
jowars16369653_jowars
loofahs13364623loofahs
loofas9429833loofa_s
molars85517323_molars
oars46846033__o_ars
ofays11488923__ofays
polars84419353_polars
roars55622243_ro_ars
roofers105013903roofers
safari91110223s_afari
safaris101110663s_afaris
saggars93610683saggars
sambars115113843sambars
samovars1343703samovars
sangars83116253sangars
sansars73313913sansars
sardars83112903sardars
sarsars73512143sarsars
scalars93711903scalars
scars75433533s__cars
schmears1584103schmears
scholar1236953scholar_
scoffers16286133scoffers
scoffs14347503scof_fs
scorers94115323scorers
scoters93313813scoters
scours84913593sco_urs
sears54744913s__ears
secpars1138413secpars
seggars9377783seggars
serovars1145233serovars
sewars94018633s_ewars
shaders115915553shaders
shads95124483sh__ads
shafts125411443shaf_ts
shags95123863sh__ags
shahs115919513sh__ahs
shakers144015563shakers
shamans123610903shamans
shamas113717943shama_s
shams105829413sh__ams
shapers124016893shapers
shard96125963sh__ard
shards104319173sh__ards
share86437083sh__are
sharers104720623sharers
shares95236413sh__ares
shark126225023sh__ark
sharks135019723sh__arks
sharn84823703sh__arn
sharns95516983sh__arns
sharp104922533sh__arp
sharps115516083sh__arps
shavers134115093shavers
shaws116226263sh__aws
shays116021433sh__ays
sheafs124912883sh_eafs
sheals94420643sh_eals
shear85424833sh_ear_
sheas86331793sh_ea_s
sheers94322403sh_eers
shewers134312053shewers
shibahs15275643shibahs
shiers94921753sh_iers
shifters14319863shifters
shifts124412943shif_ts
shikar1336803shikar_
shikari1444513shikari
shikaris1544923shikaris
shiners104015943shiners
shirrs94413173sh_irrs
shivahs16375723shivahs
shivas124512413shiva_s
shivers133714833shivers
shmear1176933shmear_
shnaps1148083sh_naps
shoal83920273sho_a_l
shoaly124010773sho_aly
shoat85633953sho_a_t
shockers17319463shockers
shocks154414583sho_cks
shoepacs1543833shoepacs
shoer84722163sho_er_
shoes85429663sho__es
shogis103810943sho_gis
shogs95319713sho__gs
shoguns1134423shoguns
shojis16348493sho_jis
sholoms1278033sholoms
shooks134515633sho_oks
shools94919013sho_ols
shoos84226363sho__os
shooters112811583shooters
shoots94619363sho_ots
shophar1555463shophar_
shoppers153010763shoppers
shoppes143411403shoppes
shops104222903sho__ps
shoran94016043shora_n
shore85432653sho__re
shores94830413sho_res
shorl84720253sho__rl
shorls94516203sho_rls
shorn85722183sho__rn
short85040533sho__rt
shorts95321743sho_rts
shotes95321913sho_tes
shots84730853sho__ts
shotts93614703sho_tts
shouters113510623shouters
shouts94017723sho_uts
shovels13378393shovels
shover124515993shover_
shoves124919423sho_ves
shower124315113shower_
showery16437243showery
shows115324583sho__ws
shoyus1266003sho_yus
shroffs1634363shrof_fs
shwas116415103sh_wa_s
shyers124712203sh_yers
simars84916933s_imars
sirdars8228213sirdars
sitars65417593s_itars
sizars154812623s_izars
skoals10438243sko_als
slogans8407983slogans
slopers94213093slopers
smears84714433s_mears
smokers13389323smokers
snorers74313803snorers
soaks95220293s_o_aks
soaps75120713s_o_aps
soar46838673s_o_ar_
sobas74424253s_oba_s
sobers85218863s_obers
socas74026183s_oca_s
sodas64123543s_oda_s
sofa75625603s_ofa__
softas94410403s_oftas
softs85019233s_of_ts
sojas124716393s_oja_s
solans64122493s_olans
solar55927343s_olar_
somans84619303s_omans
somas76030373s_oma_s
sonar56523423s_onar_
sooners73916643sooners
sopors85215203s_opors
soras55041013s_ora_s
souari6311383s_ouari
souaris7312333s_ouaris
soucars938423soucars
sours55230503s_o_urs
sowans94215893s_owans
sowar85821343s_owar_
sowcars1236013sowcars
sowers94923443s_owers
soyas84520913s_oya_s
spars75431543s__pars
spears84019473s_pears
spoofers13307323spoofers
spoors84014033spo_ors
stars55836573s__tars
stoas55126023sto_a_s
stoats65117483sto_ats
stokers114515183stokers
stomas84816323stoma_s
stoners74817953stoners
stopers94217373stopers
storers75018683storers
stours65015633sto_urs
stovers103713733stovers
suffari1345503suffari
suffaris1445083suffaris
suffers133113543suffers
sugars7312423s_ugars
sulfas9311563sulfa_s
sulfurs1037343sulfurs
surfers103614133surfers
swears94114073s_wears
thenars10248523thenars
tolars64817943_tolars
trocars959043trocars
twofers1364053twofers
woofers133810583woofers
zaffars22325233zaffars

Search took 8 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.406440125.6
2DLD Change Limit1340272526.51620568.9
3Display Results2522520.0803150.0
 (SQL Overall)1786912527.00225520.0
 
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.