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

129 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
whinnied1528415(None) 
hinnied11348101_hinnied
shinnied12345821shinnied
whinnier14255001whinnier
whinnies14237271whinnies
chinned134810492chinn_ed
hinnies103615102_hinnies
shinned114310912shinn_ed
shinnies113010912shinnies
thinned11399162thinn_ed
whimsied1743112whimsied
whined134715202whi_n_ed
whinged15409152whi_nged
whinier134110632whi_nier
whinniest15245132whinniest
whirried15154102whirried
winned104017012w_inn_ed
binned94414543_binn_ed
chined125620063chi_n_ed
chinked174011023chi_nked
chinkier17377363chinkier
chinning14329653chinning
chivied16368383chi_vied
chivvied2052523chivvied
crannied1137893crannied
dinned84317613_dinn_ed
finned104114603_finn_ed
finnier10319953_finnier
ginned83813983_ginn_ed
ginnier8298983_ginnier
grinned9378553grinn_ed
hennaed1135103_hennaed
hinged114618923_hi_nged
hinkier143610793_hinkier
hinted104318323_hi_nted
hongied12308163_hongied
honied104818393_h_onied
inned64118423__inn_ed
minnies93617363_minnies
ninnies73713613_ninnies
phonied133710563ph_onied
pinned94818383_pinn_ed
pinnies93318443_pinnies
pinniped1343853_pinniped
quinsied1845043quinsied
shannies113411253shannies
shimmied16294983shimmied
shindies122610503shindies
shined104620783shi_n_ed
shingled13358323shingled
shinier104113143shi_nier
shinney13368293shinn_ey
shinneyed1642083shinneyed
shinning123211023shinning
shunned11417843shunn_ed
sinned73818413_sinn_ed
skinned12387293skinn_ed
skinnier1264893skinnier
spinnies103210543spinnies
squinnied1942673squinnied
thinner10358973thinn_er
thinning12319093thinning
thinnish1454873thinnish
tinned74317533_tinn_ed
tinnier72910143_tinnier
twinned11366333twinn_ed
wanned104318013w_ann_ed
wennier10318603w_ennier
whanged15447613wh_anged
wherried15175013wherried
whidded1634423whi_dded
whiffed2064473whi_ffed
whiffled2133043whiffled
whiled134514133whi__led
whimsies1635193whimsies
whine116022813whi_n_e_
whiner124516633whi_n_er
whines125120103whi_n_es
whiney155012643whi_n_ey
whinge134311543whi_nge_
whinger1410810913whi_nger
whinges143610633whi_nges
whinging16247743whinging
whiniest14298753whi_niest
whininess1535123whininess
whining143311673whi_ning
whinny15587493whinn__y
whinnying19172733whinnying
whipped18379333whi_pped
whippier18265823whippier
whirled14368043whi_rled
whirlier14175293whirlier
whirlies14167373whirlies
whirred14386933whi_rred
whirries14136693whirries
whished17428023whi_shed
whishted1843153whishted
whisked18336913whi_sked
whiskies1835953whiskies
whisted144010013whi_sted
whistled1595783whistled
whited134814083whi__ted
whitened1535173whitened
whitier133311063whi_tier
whities133113253whi_ties
whittled1594913whittled
whizzed2234063whi_zzed
whizzier2233283whizzier
wienie9229973w_ienie_
wienies102213683w_ienies
willied114611563w_illied
winced124415343w_i_nced
winched163110593w_inched
winded114918213w_i_nded
windier113412163w_indier
windled123713483w_indled
wined94434183w_i_n_ed
winged114620833w_i_nged
wingier113413283w_ingier
winier94522453w_i_nier
winked144018603w_i_nked
winkled15299593w_inkled
winner94219933w_inn_er
winning113516553w_inning
winnowed1543473w_innowed
wintled11339843w_intled
wonned104012063w_onn_ed
wringed123710193wri_nged
wrinkled16275353wrinkled

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.450397091.1
2DLD Change Limit1461621296.95321021.4
3Display Results1291290.0632047.6
 (SQL Overall)1786911297.46623934.0
 
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.