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 “whimsied” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
whimsied174311(None) 
whimsies1635191whimsies
shimmied16294982shimmied
whimsey18373892whims_ey
whinnied15284152whinnied
whirried15154102whirried
whished17428022whi_shed
whisked18336912whi_sked
whisted144010012whi_sted
chammied18215973chammied
chimed145814833chim__ed
chivied16368383chi_vied
chivvied2052523chivvied
daisied93410013dai_sied
flimsier1344133flimsier
flimsies1335783flimsies
gipsied1135873_gipsied
hinnied11348103_hinnied
hirsled11118113_hirsled
hissed104114453_hi_ssed
hissier103410503_hissier
hissies103915823_hissies
histed104420243_hi_sted
jimmied19275033_jimmied
primsie1137543primsie_
quinsied1845043quinsied
shammied16265543shammied
shimmed15338583shim_med
shimmies15287803shimmies
shinnied12345823shinnied
shipside1445033shipside
slimsier1085213slimsier
stimied10310623stim_ied
thirsted1235213thirsted
waisted114210943wai_sted
whammed18345133wham_med
whammies18265513whammies
wherried15175013wherried
whidded1634423whi_dded
whiffed2064473whi_ffed
whiffled2133043whiffled
whiled134514133whi__led
whimbrel1842433whimbrel
whimper17297723whim_per
whimpered20144023whimpered
whims134515333whims___
whimseys19322463whimseys
whimsical1952233whimsical
whimsy17375223whims__y
whined134715203whi__ned
whinged15409153whi_nged
whinier134110633whi_nier
whinnier14255003whinnier
whinnies14237273whinnies
whipped18379333whi_pped
whippier18265823whippier
whipsawed2141853whipsawed
whirled14368043whi_rled
whirlier14175293whirlier
whirlies14167373whirlies
whirred14386933whi_rred
whirries14136693whirries
whishes16309443whi_shes
whishted1843153whishted
whisker17367933whi_sker
whiskey20445583whi_skey
whiskies1835953whiskies
whisper15298013whi_sper
whistled1595783whistled
whited134814083whi__ted
whitened1535173whitened
whitier133311063whi_tier
whities133113253whi_ties
whittled1594913whittled
whizzed2234063whi_zzed
whizzier2233283whizzier
whomped18345473whom_ped
whooshed1833453whooshed
whumped18335633whum_ped
willied114611563w_illied
wimbled15298153w_imbled
wimped144211513w_im_ped
wimpier14248053w_impier
wimpled15338823w_impled
wised95123343w_i_s_ed
wished134417513w_i_shed
wisped123411893w_i_sped
wissed104114643w_i_ssed
wisted104120273w_i_sted
wormseed1442963wormseed

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.1561145455.1
2DLD Change Limit146162907.42319690.4
3Display Results90900.0303000.0
 (SQL Overall)178691907.60923484.2
 
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.