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

74 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
smallage114518(None) 
smallages1245291smallages
diallage1045232diallage
millage103112752_millage
salvage1138192s_alvage
scalage103110532sca_lage
spillage1146262spillage
sullage859912s_ullage
tallage82712072_tallage
allege74314653__allege
anlage72514233__anlage
ballade104012563_ballade
collage102813763_collage
diallages1145463diallages
gallate83417133_gallate
grillage1055613grillage
haulage1136913_haulage
haylage1436443_haylage
hypallage1851643hypallage
malate84624563_ma_late
maleate94117543_maleate
mallard10310273_mallard
mallee84525593_mall_ee
maltase938903_maltase
manage93818903_ma_nage
massage1039893_massage
meltage1037953_meltage
milage93414123_m_ilage
mileage10299313_mileage
millages113212903_millages
moulage1037903_moulage
pillage103412603_pillage
salpae84614273s_alpa_e
salvaged1335363s_alvaged
salvagee1246483s_alvagee
salvager1235593s_alvager
salvages1238123s_alvages
sausage847193s_ausage
savage10410173s_a_vage
scalade10359263sca_lade
scalages113010253sca_lages
scalare93311843sca_lare
seallike12108323seallike
seaplane1049163seaplane
selvage1136553s_elvage
silage72715303s__ilage
small74016263small___
smaller93410333small_er
smallest1039403smallest
smallish1346573smallish
smallpox1941843smallpox
smalls84514123small__s
smalltime1342193smalltime
smaltine1037833smaltine
smaltite1046903smaltite
smaragd1134393sma_ragd
smaragde1242833sma_ragde
soakage1236103soa_kage
soilage8169353s_oilage
spallable1345833spallable
spillages1256083spillages
spoilage11195373spoilage
stalag7310023sta_lag_
stalags838643sta_lags
stealage946583stealage
stellate8310503stellate
sullages939973s_ullages
tallaged10257923_tallaged
tallages92312003_tallages
tillage83111343_tillage
tollage82610163_tollage
ullage739043__ullage
vallate103016563_vallate
village113610833_village

Search took 9 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.420425454.8
2DLD Change Limit146162747.70618967.3
3Display Results74740.0302466.7
 (SQL Overall)178691748.15621909.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.