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

104 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
flashily173547(None) 
fleshily1744531fleshily
classily1336622classily
fishily1637642f_ishily
flabbily1843352flabbily
flakily1736292fla_kily
flashier1437102flashier
flashing153711552flashing
flashy15498172flash__y
fleshly16346092flesh_ly
flossily1434522flossily
glassily1235462glassily
plushily1664422plushily
slushily1445012slushily
splashily1742962splashily
trashily1437322trashily
brashly15427613brash_ly
brassily1336623brassily
bushily15268893_bushily
clammily1743633clammily
clashing143812193clashing
classify1644693classify
cushily15257923_cushily
easily9313023_eas_ily
falsely1336013fals_ely
falsify1643613fals_ify
falsity1335903fals_ity
family143311703f_a_mily
fancily1538253f_ancily
fashing144918793f_ashing
fashion1337843f_ashion
fattily13379463f_attily
feasibly1644743feasibly
feistily1445263feistily
filthily1743663filthily
flaccidly2041773flaccidly
flagship1743613flagshi_p
flagships1843703flagships
flail85316183fla__il_
flails94313003fla__ils
flash115716213flash___
flashbulb1951563flashbulb
flashed144112183flash_ed
flasher133914063flash_er
flashers143912653flashers
flashes133916103flash_es
flashgun1542173flashgun
flashiest1557983flashiest
flashings16316663flashings
flatly123110213fla__tly
flauntily1542653flauntily
fleecily1644013fleecily
fleshier1435603fleshier
fleshing15339303fleshing
fleshy15406283flesh__y
flightily1943353flightily
flimsily1643283flimsily
flintily1434893flintily
floppily1843773floppily
fluffily1652923fluffily
flukily1735213fl_ukily
flushing15288833flushing
foamily1546543foa_mily
folksily1843443folks_ily
freshly16286833fresh_ly
friskily1834503friskily
frostily1436693frostily
frothily1745303frothily
fussily13267603f_ussily
fustily133111373f_ustily
gassily1137813_gassily
glazily2035383gla_zily
glossily1235093glossily
grassily1236433grassily
gushily14257823_gushily
hastily133010663_hastily
lacily11612763_la_cily
lankily1437123_lankily
lashing114422893_lashing
lashins103915153_lashins
lastly93310873_las_tly
lazily1859713_la_zily
lushly12247343_lush_ly
lustily103611243_lustily
mushily152410093_mushily
nastily103011033_nastily
plaguily1443513plaguily
plashier1337613plashier
plashing143311063plashing
plashy14448873plash__y
plasticly1644763plasticly
plushly15385383plush_ly
pushily15247983_pushily
rashly123410213_rash_ly
sassily1038723_sassily
shily115222013___shily
slangily1235383slangily
slashing123713413slashing
slashingly1743863slashingly
squashily2442793squashily
tastily103311643_tastily
waspily1535513_waspily
wrathily1744773wrathily
yeastily1444573yeastily

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.406440125.6
2DLD Change Limit1461621046.68621860.9
3Display Results1041040.0462260.9
 (SQL Overall)1786911047.13825033.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.