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

138 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
whelkier183325(None) 
chalkier1736752chalkier
cheekier1735102cheekier
hulkier14328972_hulkier
shellier1138392shellier
shelvier1464912shelvier
whackier2044672whackier
wheezier2333342wheezier
whelkiest1943962whelkiest
wieldier1234282wieldier
atelier7311623atel_ier
balkier134111983_balkier
baulkier1433533baulkier
beakier134012163_beakier
belier84423563_bel_ier
bulkier134111513_bulkier
checker18329533check_er
cheerier1348003cheerier
cheesier1335963cheesier
chertier1387873chertier
chestier1387423chestier
chewier1537593che_wier
chillier13328423chillier
chinkier17377363chinkier
chokier1638043ch_okier
chunkier17395883chunkier
creakier14328333creakier
eelier64216463_eel_ier
elmier839813__elmier
folkier14359043_folkier
freakier15246483freakier
geekier12286393_geekier
headier113212953_headier
heavier13429423_heavier
heckler16278573_heckler
hedgier12367883_hedgier
heftier1337203_heftier
heller93322513_hel_ler
helper114313093_hel_per
hempier14319003_hempier
herbier1239593_herbier
hillier103413963_hillier
hinkier143610793_hinkier
hokier134214033_h_okier
holier94921623_hol_ier
hookier143811673_hookier
hunkier144512143_hunkier
huskier14369763_huskier
jerkier18407273_jerkier
leakier114010993_leakier
milkier133411163_milkier
peakier134411443_peakier
peckier153910523_peckier
perkier133813123_perkier
peskier13319113_peskier
reekier113111123_reekier
relier65826183_rel_ier
rheumier1342513rheumier
selkie102811693_selkie_
selkies113513353_selkies
shakier143411153sh_akier
shalier103116423shal_ier
sheenier11167423sheenier
sheller103515883shel_ler
shelter103214963shel_ter
sheltie10109913sheltie_
shelties111111383shelties
shelver134211063shel_ver
silkier114411643_silkier
sleekier1245573sleekier
smellier1036793smellier
sneakier1245143sneakier
stalkier1257073stalkier
sulkier113811963_sulkier
talkier114011843_talkier
thewier1336063the_wier
tweakier1533143tweakier
wackier16369733w_ackier
walker133913993w_alk_er
weaker134015443w_eak_er
weaklier1534263w_eaklier
wearier103613283w_earier
webbier1445423w_ebbier
wedgier12428283w_edgier
weedier113810623w_eedier
weeklies1534913weeklies
weenier103210803w_eenier
weensier1134243weensier
weepier12319273w_eepier
welcher15319393w_elcher
welder102914413w_el_der
welkin1337313w_elki_n
welkins1437173w_elkins
wellie92814913w_ellie_
wellies103719073w_ellies
welsher13377443w_elsher
welter93417383w_el_ter
wennier10318603w_ennier
whacker19368503whack_er
whaler124611973whal__er
wheedler1543543wheedler
wheeler13298773whe_eler
wheelie1336193wheelie_
wheelies1437863wheelies
wheezer22296673whe_ezer
whelk154311063whelk___
whelks16367323whelk__s
whelky19314973whelk__y
whelmed16375153whel_med
whelming17304923whelming
whelped16355633whel_ped
whelping17245333whelping
whenever1742773whenever
wherever1743823wherever
wherried15175013wherried
wherries14179023wherries
whether16346623whe_ther
whetter13348803whe_tter
wheylike2143403wheylike_
whicker19359773whick_er
whinier134110633wh_inier
whinnier14255003whinnier
whippier18265823whippier
whirlier14175293whirlier
whisker17367933whisk_er
whiskies1835953whiskies
whitier133311063wh_itier
whizzier2233283whizzier
wielder11197673wiel_der
wifelier1434853wifel_ier
wilier93217073w_il_ier
wiselier1137363wisel_ier
wonkier1437423w_onkier
woolier103612353wool_ier
woollier1155433woollier
wreaker143610043wreak_er
wrecker16367603wreck_er
yolkier14336123_yolkier

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.423422437.4
2DLD Change Limit1461621386.53022383.2
3Display Results1381380.0632190.5
 (SQL Overall)1786911387.01625469.1
 
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.