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

88 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
asswage114467(None) 
assuage835681assuage
asswaged1343331asswaged
asswages1255051asswages
assuaged1044382assuaged
assuager944342assuager
assuages936272assuages
massage1039892mass_age
passage1039802pass_age
sewage10310732_sewage
swage94919562__swage
acreage1037843acreage
adage7414053a__dage
airwave1344433airwave
ambage11510603a_mbage
anlage72514233a_nlage
ansae55720973ans_a_e
ansate64517863ans_ate
apanage1036803apanage
ashcake1663373ashcake
assagai843903ass_agai
assai5711543ass_a_i
assail6610153ass_ail
assais6711963ass_ais
assay8710283ass_a_y
assayed1135593ass_ayed
assayer1035573ass_ayer
assays977903ass_ays
assegai843353assegai
asshole1046793asshole
assign736783ass_ign
assize1538633ass_ize
asslike1137373asslike
assuagers1043473assuagers
assume897563ass_ume
assure6610773ass_ure
asswaging1443103asswaging
aswarm11107913a_swarm
average1158853average
awake125014783a__wake
aware86420023a__ware
boscage1276533boscage
boskage1465413boskage
brassage1145283brass_age
brassware1463813brassware
brewage1347183brewage
cowage12310673_cowage
dosage82810003dos_age
escuage1035113escuage
flowage1435723flowage
glassware1343223glassware
hostage113111233hostage
massaged1236753mass_aged
massager1136873mass_ager
massages1159883mass_ages
message1037833message
messuage1144523messuage
mispage12310523mispage
nonwage1137163nonwage
onstage838363onstage
passade1039233pass_ade
passaged1236243pass_aged
passages1139513pass_ages
postage103214853postage
restage83316193restage
sage55044593__s_age
salvage1138193salvage
sausage847193sausage
savage10410173_savage
sewages1139753_sewages
silage72715303_silage
socage91012123_socage
stage65330193__stage
stowage1136703stowage
swag87526733__swag_
swaged114212253__swaged
swager104013613__swager
swages104417073__swages
swags94921253__swags
swale85221593__swale
sware85828213__sware
towage1039833_towage
upstage10167443upstage
usage6410213_us_age
vassalage1342153vassalage
visage1049083vis_age
wage84834083___wage
wastage11109253wastage

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 Filter1786911340270.406440125.6
2DLD Change Limit134027886.89319443.9
3Display Results88880.0302933.3
 (SQL Overall)178691887.32924381.4
 
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.