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

149 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
chukka143301(None) 
chukkar1542051chukkar
chukkas1532781chukkas
chakra15437532chakra
charka154011702charka
chuck164814872chuck_
chucks174812932chucks
chucky20418002chucky
chufa13489112chu_fa
chukar1534632chukar
chukkars1642002chukkars
chukker1543832chukker
chunk144812382chunk_
chunks154210332chunks
chunky18468272chunky
chuppa1543972chuppa
pukka10457132_pukka
bhakta1533653bhakta
burka114617693_burka
caulk115315453caulk_
caulks125611863caulks
chachka21173643chachka
chacma1537903chacma
chaeta11310683chaeta
chakras16428483chakras
chalk144814603chalk_
chalks155412143chalks
chalky18468773chalky
challa114014193challa
chark144222713chark_
charkas164810953charkas
charkha19405153charkha
charks155219703charks
check164714713check_
checks174912703checks
cheek145115713cheek_
cheeks154712783cheeks
cheeky18448613cheeky
chela103916803ch_ela
chia96026623ch__ia
chica125818263ch_ica
chick165419133chick_
chicks175317593chicks
chimla1337593chimla
china105022473ch_ina
chink145321593chink_
chinks155817573chinks
chinky185610543chinky
chirk144516183chirk_
chirks155414843chirks
choana1138443choana
chock164316613chock_
chocks174815313chocks
choke145118023ch_oke
choked164914793choked
choker154314373choker
chokes154917383chokes
chokey184811713chokey
choky175711223ch_oky
chola104718033ch_ola
cholla113911023cholla
chook146015043chook_
chooks155312793chooks
chorea115216083chorea
chroma132912473chroma
chub115516413chu__b
chubby1844123chubby
chubs125412623chu_bs
chucked19469733chucked
chuckle1836443chuckle
chuddah17263253chuddah
chuddar14263963chuddar
chufas14397673chufas
chuff164812493chu_ff
chuffs17427783chuffs
chuffy20445863chuffy
chug105914113chu__g
chugs115511943chu_gs
chukars1634273chukars
chukkers1633473chukkers
chum116318003chu__m
chummy18385893chummy
chump145315443chu_mp
chumps154313823chumps
chums125015833chu_ms
chunked17428213chunked
chuppah1952453chuppah
chuppas1644123chuppas
church1636483church
churl105913883chu_rl
churls115411073churls
churn105113103chu_rn
churns114910233churns
churr104512853chu_rr
churro11448353churro
churrs115111513churrs
chute104316463chu_te
chuted124611843chuted
chutes114615763chutes
chutzpa2361763chutzpa
cluck134914893cluck_
clucks144512073clucks
clunk114215083clunk_
clunks124811013clunks
clunky15447893clunky
cruck135615323cruck_
crucks144412583crucks
crura7312583cru_ra
cuke105824983c_u_ke
cukes115422093c_ukes
culpa93610963c_ulpa
cuppa11398523c_uppa
curia74523763c_uria
cusk105521633c_usk_
cusks114916053c_usks
dhurna1043563dhurna
dumka12438833_dumka
haika125313793_haika
hokku1135483_hokku
hooka125513903_hooka
huck135927633_huck_
hucks144322173_hucks
hula74923753_hu_la
hulk115321613_hulk_
hulks125715483_hulks
hulky155312473_hulky
hunk116029543_hunk_
hunks125321453_hunks
hunky155417733_hunky
husk116021953_husk_
husks125015453_husks
husky156112563_husky
huzza1646093_huzza
markka11416593markka
pucka133412803_pucka
punka114515483_punka
quokka1841893quokka
rhumba13375553rhumba
shiksa1394653shiksa
shuck144314533shuck_
shucks154010413shucks
sukkah12123733_sukkah
thuja1535213thu_ja
thulia936113thulia
thunk124911853thunk_
thunks13459033thunks
thuya1135583thu_ya
tikka835573_tikka
yukky14425213_yukky

Search took 6 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 Filter1786911127160.1231452772.4
2DLD Change Limit1127161495.56320261.7
3Display Results1491490.0463239.1
 (SQL Overall)1786911495.73231174.3
 
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.