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

153 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
whackos1937526(None) 
shackos16429021shackos
wackos155210991w_ackos
whacko18477031whacko_
whacks184610481whack_s
hacks144928712_hack_s
shacko153810112shacko_
shackoes17367852shackoes
shacks154817562shack_s
shakos134912192sha_kos
thacks154311922thack_s
wackes154717712w_ackes
wacko145514382w_acko_
wacks146626282w_ack_s
whack174813022whack__
whacked20458622whacked
whacker19368502whacker
whackers20326542whackers
whacky21556492whack_y
wracks154711112wrack_s
askos95011773__askos
backs135729623_back_s
blacks144914953black_s
buckos143710893_buckos
cacaos104616183_cacaos
chachkas22173733chachkas
chacmas1638003chacmas
chalks155412143chalk_s
chaos105622863cha__os
charkas164810963charkas
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
sacks114228873_sack_s
shack145321753shack__
shacked174015393shacked
shackle16409543shackle
shackles173010593shackles
shakes135024593sha_kes
shako125516093sha_ko_
shakoes144510023sha_koes
shammos14307203shammos
shamos114216983sha_mos
shanks135315583shank_s
sharks135019723shark_s
shocks154414583shock_s
shucks154010413shuck_s
sickos125112033_sickos
slacks124416533slack_s
smacks144112323smack_s
snacks124514553snack_s
stacks124317263stack_s
tacks115430133_tack_s
tacos77023553_tac_os
thack144915173thack__
thacked173810203thacked
thanks134313133thank_s
thicks154511993thick_s
thwacks1953613thwack_s
tracks124818843track_s
wack135330913w_ack__
wacke145918623w_ack_e
wacker154920123w_acker
wackest164710863w_ackest
wacky174714933w_ack_y
wahoos122310593w_ahoos
wakes126633653w_a_kes
walks126218503w_alk_s
wanks126124483w_ank_s
warks127932403w_ark_s
wauks125515163w_auk_s
wazoos18288553w_azoos
weakon13357623wea_kon
weakons14287803wea_kons
whackier2044673whackier
whackiest2144983whackiest
whacking21377483whacking
whalers13529703whalers
whales124716943wha_les
whammo16405193whammo_
whamo135511263wha_mo_
whams135515643wha__ms
whangs13439723wha_ngs
whaps135115163wha__ps
wharfs1546373wha_rfs
wharves16457133wharves
whatnot1344733whatnot
whatnots1442303whatnots
whats117718993wha__ts
whatsis1335253whatsis
whaups14405753wha_ups
whelks16367323whelk_s
whicker19359773whicker
whickers20297983whickers
whisks16497353whisk_s
wicks144619363w_ick_s
wrack145413883wrack__
wracked174110113wracked
wrecks15418883wreck_s
wricks154610623wrick_s
yacks144419813_yack_s

Search took 7 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.393454684.5
2DLD Change Limit1340271536.32621186.7
3Display Results1531530.0632428.6
 (SQL Overall)1786911536.78226347.8
 
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.