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

277 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
shackos1642902(None) 
shacko153810111shacko_
shackoes17367851shackoes
shacks154817561shack_s
shakos134912181sha_kos
whackos19375261whackos
hacks144928712_hack_s
sacks114228872s_ack_s
shack145321752shack__
shacked174015392shacked
shackle16409542shackle
shackles173010592shackles
shakes135024592sha_kes
shako125516082sha_ko_
shakoes144510012sha_koes
shammos14307202shammos
shamos114216982sha_mos
shanks135315582shank_s
sharks135019722shark_s
shocks154414572shock_s
shucks154010412shuck_s
sickos125112032s_ickos
slacks124416532slack_s
smacks144112322smack_s
snacks124514552snack_s
stacks124317262stack_s
thacks154311922thack_s
wackos155210992_wackos
whacko18477032whacko_
whacks184610482whack_s
ashcakes1753733ashcakes
askos95011773__askos
backs135729623_back_s
blacks144914953black_s
buckos143710893_buckos
cacaos104616183_cacaos
chachkas22173733chachkas
chacmas1637993chacmas
chalks155412143chalk_s
chaos105622863cha__os
charkas164810953charkas
charks155219703chark_s
charros124312143charros
checks174912703check_s
chicks175317593chick_s
chicos134614833chic_os
chocks174815313chock_s
chucks174812933chuck_s
clacks144516343clack_s
cracks144817003crack_s
dhaks13479703dha_k_s
flacks154114533flack_s
geckos13457433_geckos
guacos94410313guac_os
haceks15447863_haceks
hack135134543_hack__
hacked164923513_hacked
hackee154921833_hackee
hackees165014103_hackees
hacker154822693_hacker
hackers164619043_hackers
hackie154615623_hackie
hackies163418243_hackies
hackle154916813_hackle
hackles162917063_hackles
hackly18298733_hackly
haiks125120933_haik_s
haikus13538293_haikus
hakes126034303_ha_kes
hakus125114113_ha_kus
hallos95425103_hallos
halos85230253_ha_los
hanks126226863_hank_s
harks126333433_hark_s
hawks155415703_hawk_s
hecks145220653_heck_s
hicks145322173_hick_s
hocks144925493_hock_s
hucks144322173_huck_s
jacks185219833_jack_s
jockos19527563_jockos
khakis1265853kha_kis
knacks11428543knack_s
kyacks14416063kyack_s
lacks116129203_lack_s
machos135217493_machos
macks135127603_mack_s
macros104017013_macros
makos116518363_ma_kos
nachos115014183_nachos
packs135528933_pack_s
pharos11312063pha_ros
placks144414153plack_s
quacks214710103quack_s
racks115028853_rack_s
rhachis1555693rhachis
sack105337313s_ack__
sacked135525213s_acked
sacker125124843s_acker
sackers133820223s_ackers
sacs65739073s_ac__s
sagos66123873s_a_gos
sakes95540753s_a_kes
sakis95323663s_a_kis
salvos94613383s_alvos
sambos104315193s_ambos
santos64421833s_antos
sargos74318273s_argos
sarks96632463s_ark_s
saros55238063s_a_ros
seccos1039923s_eccos
shacking184014083shacking
shackled18277593shackled
shackler17317973shackler
shacklers18336033shacklers
shaders115915553shaders
shades105924533sha_des
shadoof1446133shadoof
shadoofs1554233shadoofs
shadow1337253sha_dow
shadows1437193shadows
shads95124483sha__ds
shadufs1433673shadufs
shafts125411433sha_fts
shags95123863sha__gs
shahdom1643963shahdom
shahdoms1743773shahdoms
shahs115919513sha__hs
shairds11216263shairds
shairns10276783shairns
shake124726403sha_k_e
shaken134113613sha_ken
shaker134319463sha_ker
shakers144015563shakers
shaky154616843sha_k_y
shales94731253sha_les
shallop12348453shallop
shallops13288313shallops
shallot103614133shallot
shallots11319493shallots
shallow13388873shallow
shallows14388853shallows
shalom11810913sha_lom
shaloms1288983shaloms
shamans123610893shamans
shamas113717933sha_mas
shames114726223sha_mes
shammas14358713shammas
shammes144312833shammes
shamois123210403shamois
shamoy14379913sha_moy
shamoys15367283shamoys
shampoo1435373shampoo
shampoos1544603shampoos
shams105829413sha__ms
shamus114112813sha_mus
shank125422193shank__
shanked153212123shanked
shantis103313083shantis
shapers124016893shapers
shapes115124943sha_pes
shards104319173sha_rds
sharers104720623sharers
shares95236413sha_res
sharias102516003sharias
sharifs13279903sharifs
shark126225023shark__
sharked153613903sharked
sharker144313813sharker
sharkers154011053sharkers
sharns95516983sha_rns
sharps115516083sha_rps
shaughs14245283shaughs
shauls94913113sha_uls
shavers134115093shavers
shaves125224933sha_ves
shavies134213203shavies
shawls125411973sha_wls
shawms14579563sha_wms
shaws116226263sha__ws
shays116021433sha__ys
sheikhs17233993sheikhs
sheiks132510013sheik_s
shicker163914823shicker
shickers173012823shickers
shicksa1634103shicksa
shicksas1743523shicksas
shirks134814123shirk_s
shlocks16317173shlock_s
shmucks1833943shmuck_s
shnooks1485573shnooks
shock144917023shock__
shocked174611803shocked
shocker163411423shocker
shockers17319463shockers
shooks134515623shook_s
shoos84226353sh__oos
shrikes144412393shrikes
shticks16356963shtick_s
shtiks13297823shtik_s
shuck144314533shuck__
shucked17389833shucked
shucker163710103shucker
shuckers17388133shuckers
sicko115315393s_icko_
sicks115127623s_ick_s
skanks94710833skank_s
slack115021763slack__
slacked143815453slacked
slacken13399933slacken
slackens14367713slackens
slacker133915293slacker
slackers143812743slackers
slackest14289393slackest
slackly1635263slackly
slakes104021883sla_kes
slicks124816113slick_s
smack134615453smack__
smacked163710993smacked
smacker153410583smacker
smackers16318713smackers
smaltos9408193smaltos
smocks145710013smock_s
snack114718063snack__
snacked144013113snacked
snacker133112603snacker
snackers143010223snackers
snakes103919603sna_kes
snarks104815733snark_s
snecks124410033sneck_s
snicks124312473snick_s
soaks95220293soa_k_s
socko115215113s_ocko_
socks114926083s_ock_s
spacers113813873spacers
spaces104722633spac_es
spacious1237813spacious
spackle15369563spackle
spackles16319943spackles
spanks124514123spank_s
sparks124616363spark_s
specks144312703speck_s
spicks144814993spick_s
stack114421693stack__
stacked143416123stacked
stacker134416263stacker
stackers143413563stackers
stackup1533743stackup
stackups1643313stackups
stactes91914633stactes
stakes103927293sta_kes
stalks104614553stalk_s
stanks104917703stank_s
sticks125118613stick_s
stocks124715633stock_s
stuccos1153933stuccos
sucks114523073s_uck_s
swacked173110523swacked
swanks134811563swank_s
tacks115430133_tack_s
tacos77023553_tac_os
thack144915173thack__
thacked173810203thacked
thanks134313133thank_s
thicks154511993thick_s
thwacks1953613thwack_s
tracks124818843track_s
wackes154717713_wackes
wacko145514383_wacko_
wacks146626283_wack_s
whack174813023whack__
whacked20458623whacked
whacker19368503whacker
whackers20326543whackers
whacky21556493whack_y
wracks154711113wrack_s
yacks144419813_yack_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.203880251.2
2DLD Change Limit1340272777.90616952.6
3Display Results2772770.0932978.5
 (SQL Overall)1786912778.20221786.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.