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

213 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
arak8692957(None) 
araks94820881araks
ark77044961ar_k
aa219179952a_a_
aah616252962a_ah
aal39058672a_al
aas310975392a_as
aba512850952aba_
aback134816172aback
abaka114313822abaka
abas68642082abas
afar76720782afar
aga410447232aga_
agar58726412agar
agas55938842agas
aha611246642aha_
ajar116217702ajar
ala312463602ala_
alack114820062alack
alae45643752alae
alan46844082alan
alar46340072alar
alas46358122alas
ama510853302ama_
amah98927492amah
amas67746292amas
amok10217402amok
ana39559832ana_
anal48037522anal
anas46649862anas
anorak1038922anorak
apeak115513452apeak
ar211379382ar__
arame75026622arame
arb510448422ar_b
arbs66834732arbs
arc510250902ar_c
arch98628442arch
arco68331542arco
arcs67834782arcs
are37874572ar_e
area45843392area
areae55229742areae
areal55928732areal
areas55935772areas
ares45871022ares
arf67453372ar_f
arfs76029962arfs
argal65023392argal
arhat8327092arhat
aria46245422aria
arias55438022arias
arid57642712arid
aril45843022aril
arks85936872arks
arm58449622ar_m
arms66137492arms
army96624182army
arrack121110252arrack
arras55626132arras
array86317142array
ars37670932ar_s
arse46539272arse
art38679142ar_t
artal55525472artal
arts49650262arts
arty77531312arty
arum66129032arum
arval86017012arval
arvo76023432arvo
aryl75922342aryl
ask77130702a_sk
atap66722452atap
auk76234142a_uk
aura45836252aura_
aurae54128112aurae
aural54428962aural
aurar54420252aurar
auras55932562auras
ava610139322ava_
awa611939672awa_
awake125014782awake
away108024222away
axal116520492axal
ayah108022992ayah
azan136521782azan
bark106242152bar_k
beak106534382beak
bra56339462bra_
brad75234342brad
brae65639112brae
brag75229722brag
brake116025342brake
braky145015812braky
bran65740382bran
brank115222282brank
bras65746452bras
brat66055542brat
braw94829562braw
bray95232902bray
break115319402break
carack142113172carack
carat75048792carat
cark105539272car_k
crab85727672crab
crack134120532crack
crag75625302crag
crake114823522crake
cram85635492cram
crank114819612crank
crap85731842crap
craw97725262craw
creak115418432creak
croak115216632croak
dak86340692_dak
dark95133212dar_k
dhak125512032dhak
drab76226452drab
drag64825052drag
drake104918302drake
dram75832002dram
drank104816202drank
drat56247832drat
draw85623012draw
dray85428092dray
drek96321092drek
era35741502era_
eras45441502eras
farad95720672farad
flak116026172flak
frae75330472frae
frag85126272frag
frank124417512frank
frap95925812frap
frat75648542frat
fray105428902fray
freak125115242freak
grab75427612grab
grad66829862grad
gram77034582gram
gran56335012gran
grat55651282grat
gray85329892gray
grok95819682grok
hark115237392har_k
irk76426362ir_k
kaiak8310352kaiak
karat96837592karat
kayak1138362kayak
kyak105213632kyak
lark85733862lar_k
leak86233712leak
mara67444572mara_
maras75443292maras
mark105138062mar_k
marka114620792marka
nark85230062nar_k
oak76238652_oak
ora37250832ora_
orad56031692orad
oral47638122oral
para65242172para_
parae76335702parae
paras76143042paras
park105237492par_k
parka115120882parka
peak106535202peak
pram85733492pram
prank115019452prank
prao66229022prao
prat65952042prat
prau66529472prau
pray96331532pray
rack106234882rack
rad47662002_rad
rag45761322_rag
rah68052402_rah
rai37658222_rai
raj105740222_raj
rake84841572_rake
raki87127832_raki
raku85423772_raku
ram56867272_ram
ran38266622_ran
rank85135532rank
rap56261962_rap
ras37575392_ras
rat37892742_rat
raw67252252_raw
rax108445722_rax
ray66361992_ray
saran53730302saran
sark84938972sar_k
soak87227662soak
tarok97921072tarok
teak85930842teak
track114823012track
trad55630912trad
traik95418202traik
tram67034552tram
trank96222422trank
trap67532802trap
tray77632592tray
trek86222312trek
troak95213572troak
vara75530882vara_
varas86028192varas
wark115737772war_k
weak117126302weak
wrack145413882wrack
wrap96821972wrap
wreak125513272wreak
yak107038562_yak

Search took 2 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 Filter178691298720.280638182.1
2DLD Change Limit298722130.93631914.5
3Display Results2132130.0633381.0
 (SQL Overall)1786912131.279139711.5
 
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.