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

70 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
spoilage1119537(None) 
soilage8169351s_oilage
spoilages12184711spoilages
silage72715302s__ilage
soilages9189672s_oilages
spillage1146262spillage
spinage10289652sp_inage
spoilable1345162spoilable
spoliate1039242spoliate
coinage10310553_coinage
collage102813753_collage
ensilage944713ensilage
epilate9314283ep_ilate
espionage1242573espionage
foliage1147533_foliage
milage93414123__milage
moulage1037903_moulage
mucilage1344203mucilage
oppilate1245863oppilate
pelage9515363_p_elage
pillage103412593_pillage
pipage1199143_p_ipage
plage84520403_p__lage
portage103013643_portage
postage103214853_postage
potage92715903_po_tage
pottage103310603_pottage
primage12169143_primage
pupilage1343773pupilage
scalage103110533s_calage
shoelace1345293shoelace
shortage1236303shortage
sibilate1049533sibilate
silages82514443s__ilages
silane62718053s__ilane
smallage1145183smallage
soakage1236103s_oakage
socage91012123s_o_cage
soccage1236283s_occage
soilure736233s_oilure
solace83415823s_o_lace
solate64526073s_o_late
spicae104313703sp_ica_e
spicate113214193sp_icate
spile75230083sp_il__e
spillages1256073spillages
spinages11289293sp_inages
spinate93114813sp_inate
splake1259783sp__lake
spoil75818643spoil___
spoiled104811353spoil_ed
spoiler93310683spoil_er
spoilers10238633spoilers
spoiling112911553spoiling
spoils84614533spoil__s
spoilsmen1342423spoilsmen
spoilt85016593spoil__t
spoliated1246913spoliated
spoliates1138543spoliates
sponge939663spo__nge
sporulate1146953sporulate
springe103913983spri_nge
stealage946583stealage
stockage1544903stockage
stoppage1344683stoppage
storage8310473sto_rage
stowage1136703sto_wage
sullage859913s_ullage
tollage82610163_tollage
vorlage1136403_vorlage

Search took 10 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.1731032896.0
2DLD Change Limit146162709.37315593.9
3Display Results70700.0461521.7
 (SQL Overall)178691709.59218629.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.