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

276 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
whiskers1830677(None) 
whickers20297981whickers
whisker17367931whisker_
whiskery21314551whiskery
whiskeys21353381whiskeys
whispers16266991whispers
friskers15337372friskers
hikers135014352_hi_kers
hissers104112312_hissers
huskers143510042_huskers
riskers114011992_riskers
shickers173012822shickers
shikkers14326522shikkers
shirkers15319582shirkers
thinkers15308702thinkers
waisters113811522waisters
whackers20326542whackers
whicker19359772whicker_
whiffers2064492whiffers
whimpers18276612whimpers
whiners134011572whi_ners
whingers15358722whingers
whippers18329042whippers
whirlers14286052whirlers
whishes16309442whishe_s
whisked18336912whiske_d
whiskered20123392whiskered
whiskey20445582whiske_y
whiskies1835952whiskies
whisks16497352whisk__s
whisper15298012whisper_
whispery19284292whispery
whistlers1595162whistlers
whitters14359402whitters
whizzers2233422whizzers
wickers164114702w_ickers
winkers143517112w_inkers
wishers133215212w_ishers
askers105915403__askers
bickers154316553_bickers
bikers124517553_bi_kers
bilkers134711863_bilkers
bisters93922613_bisters
blinkers14388503blinkers
blisters104015083blisters
brisker134210293brisker_
briskets14346563briskets
buskers133414093_buskers
chasers123714923chas_ers
checkers19317843checkers
chickees19258513chickees
chickens19267433chickens
chiders135312943chi_ders
chiggers1535563chiggers
chillers133710923chillers
chimers144515143chi_mers
chippers173510883chippers
chirker16429323chirker_
chirpers15358133chirpers
chiselers1445453chiselers
chisels12219103chis_els
chitters133711173chitters
chokers164311523ch_okers
chukkers1633483chukkers
clickers163910203clickers
clinkers14339833clinkers
crispers12309433crispers
daikers124010313dai_kers
dickers144117663_dickers
dikers114418793_di_kers
drinkers13277823drinkers
duikers12369383dui_kers
eskers105312223__eskers
fishers134714723_fishers
flickers17338883flickers
frisker14389273frisker_
friskets15326263friskets
glisters93912603glisters
gristers94013403gristers
hackers164619043_hackers
hankers144218133_hankers
hawkers174210333_hawkers
heisters113413133heisters
hickeys19508223_hickeys
hiders104919653_hi_ders
hiker125119393_hi_ker_
hikes125426983_hi_ke_s
hillers103718733_hillers
hinders113718503_hinders
hingers113420213_hingers
hinters103719583_hinters
hipsters13268793_hipsters
hirers94518063_hi_rers
hisser94713793_hisser_
hisses94719353_hisse_s
hitters104717593_hitters
hockers163915913_hockers
hoisters113513483hoisters
honkers143315233_honkers
hookers144916523_hookers
hosers95223973_hos_ers
hosiers104212643_hosiers
hunkers143314333_hunkers
husker134212703_husker_
ickers123914183__ickers
inkers104018833__inkers
jinkers183511813_jinkers
kaisers11369273kais_ers
keisters123212043keisters
kickers124013293_kickers
kissers114211293_kissers
klisters123910483klisters
knickers13306723knickers
leisters83312823leisters
lickers134118253_lickers
likers104620913_li_kers
linkers114317713_linkers
lispers94514323_lispers
listers74026533_listers
maskers133913843_maskers
meisters103313843meisters
milkers134411613_milkers
misers85025703_mis_ers
misters93927513_misters
nickers134415093_nickers
philters1398173philters
pickers153718093_pickers
pikers124717393_pi_kers
pinkers134118603_pinkers
pishers123815753_pishers
pissers95014753_pissers
plinkers14309393plinkers
poisers94214433pois_ers
prickers163710673prickers
prinkers143010383prinkers
raisers73617393rais_ers
risers64624783_ris_ers
risker105414493_risker_
roisters83615553roisters
seisers73816393seis_ers
shakers144015563sh_akers
sharkers154011053sharkers
shicker163914823shicker_
shiers94921753shi__ers
shifters14319863shifters
shikars1436183shi_kars
shikker13277023shikker_
shiksehs1892093shiksehs
shikses14116573shikse_s
shimmers15269413shimmers
shiners104015943shi_ners
shippers153012313shippers
shirker143711343shirker_
shivers133714833shi_vers
shockers17319463shockers
shriekers16224423shriekers
shrinkers16205383shrinkers
shuckers17388133shuckers
shushers14267053shushers
shysters14106463shysters
sinkers113618543_sinkers
sisters73721593_sisters
skinkers11298183skinkers
slickers143112553slickers
smirkers14316353smirkers
snickers143010963snickers
spikers135311993spi_kers
stickers142913033stickers
stinkers123111133stinkers
swishers14328053swishers
thankers15297833thankers
thickens17266413thickens
thicker163611023thicker_
thickets17287083thickets
thinker143610683thinker_
thinners11327753thinners
thirsters1235233thirsters
tickers133617723_tickers
tinkers113517143_tinkers
trickers143812813trickers
tuskers113710043_tuskers
twisters11268173twisters
wailers103916803wai_lers
waister103812383waister_
waiters104218623wai_ters
waivers133410053wai_vers
wakers134822493w__akers
walkers143411473w_alkers
wankers144514713w_ankers
warslers11328073warslers
washers134517523w_ashers
wasters104026593w_asters
websters1335803websters
weighers15135673weighers
weiners103913063wei_ners
welshers14246813welshers
westers105221963w_esters
whacker19368503whacker_
whalers13529703wh_alers
whappers18276743whappers
wheelers14287733wheelers
wheezers23265273wheezers
whetters14246653whetters
whickered22114033whickered
whiffer19105323whiffer_
whiffets2072523whiffets
whifflers2142773whifflers
whiles124418013whi_le_s
whimper17297723whimper_
whimseys19322463whimseys
whimsies1635193whimsie_s
whiner124516633whi_ner_
whines125120103whi_ne_s
whinger1410810913whinger_
whinges143610633whinge_s
whinier134110633whinier_
whipper173611383whipper_
whippets18255253whippets
whirler13307603whirler_
whirrs12408593whi__rrs
whirs115218093whi___rs
whished17428023whishe_d
whishts16425313whis_hts
whisk154510143whisk___
whisking19286613whisking
whisky19455903whisk__y
whispered18144373whispered
whisperer17133693whisperer
whisperers18153053whisperers
whisted144010013whiste_d
whistler1496313whistler_
whistles14108213whistles
whists124613813whis__ts
whiteners1535243whiteners
whitens13428733whi_tens
whiter124316393whi_ter_
whites123919883whi_te_s
whiteys16396153whi_teys
whither163510253whither_
whitier133311063whitier_
whities133113253whitie_s
whitter139110893whitter_
whittlers1594333whittlers
whizzer2134583whizzer_
whizzes2134713whizze_s
whoopers16286263whoopers
whoppers18297533whoppers
wicker154518673w_icker_
wickets164010943w_ickets
widders123512273w_idders
wieners103212483w_ieners
wilders113513503w_ilders
willers103517913w_illers
wincers123415363w_incers
winders113721263w_inders
wingers113921483w_ingers
winker134220293w_inker_
winners104316913w_inners
winters103720483w_inters
wipers115416083w_i_pers
wirers94617893w_i_rers
wiser85522803w_is_er_
wises85633193w_is_e_s
wisher123617063w_isher_
wishes124920953w_ishe_s
wisses94619603w_isse_s
withers134417753w_ithers
wivers125320803w_i_vers
workers144612693w_orkers
wowsers13488763wows_ers
wreakers15328423wreakers
wreckers17315973wreckers
wresters112711733wresters
wringers123110073wringers
writers105513493wri_ters
writhers14398983writhers

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 Filter1786911461620.420425454.8
2DLD Change Limit1461622767.40619735.6
3Display Results2762760.1102509.1
 (SQL Overall)1786912767.93622516.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.