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

102 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
assuages93627(None) 
assuage835681assuage_
assuaged1044381assuaged
assuager944341assuager
assuagers1043461assuagers
asswages1255051asswages
assumes967162assu_mes
assures7611402assu_res
asswage1144672asswage_
asswaged1343332asswaged
escuages1145162escuages
massages1159882mass_ages
messuages1244392messuages
passages1139512pass_ages
sausages937002sausages
acreages1138363acreages
actuates10310303actuates
adages8412953a__dages
adjudges1842323adjudges
ambages1269623a_mbages
anlages82414103a_nlages
apanages1137013apanages
ashcakes1753733ashcakes
asperges11318093asperges
assagai843903ass_agai
assagais943813ass_agais
assails769093ass_ails
assais6711963ass_a_is
assaults843863assaults
assayed1135593ass_ayed
assayer1035573ass_ayer
assayers1144843ass_ayers
assays977903ass_a_ys
assegais943953assegais
asses55629283ass___es
assesses737383assesses
assholes1146743assholes
assigns836193ass_igns
assizes1638453ass_izes
assuaging1144123assuaging
assume897563assu_me_
assumed1065293assu_med
assumer965363assu_mer
assumers1064963assumers
assurances1244693assurances
assure6610773assu_re_
assured858373assu_red
assureds984493assureds
assurer767783assu_rer
assurers866303assurers
assurgent1044613assurgent
assurors894043assurors
averages1249183averages
boscages1366643boscages
boskages1565423boskages
brassages1245263brass_ages
dissuades1166243dissuades
dosages92310803dos_ages
escuage1035113escuage_
hostages122311693hostages
issuances1144643issuances
issues648803issu__es
languages11115053languages
massage1039893mass_age_
massaged1236753mass_aged
massager1136873mass_ager
massagers1245503mass_agers
messages1138233messages
messuage1144523messuage_
mispages13311183mispages
misusages1244973misusages
ossuaries944553ossuaries
passades1139203pass_ades
passage1039803pass_age_
passaged1236243pass_aged
passuses1036773passu_ses
pasturages1344923pasturages
postages112815323postages
restages92815763restages
resurges9310123resurges
sages65339063__s_ages
salvages1238123salvages
sausage847193sausage_
savages1139973_savages
scutages1136503_scutages
sewages1139753_sewages
silages82514443_silages
sludges93811993_sludges
smudges11348283_smudges
socages101012053_socages
spurges104111653_spurges
squares163714453_squares
stages75629493__stages
surges73924593__surges
swages104417073__swages
unassuaged1242393unassuaged
upstages11147373upstages
upsurges11144803upsurges
usages759603_us_ages
vassalages1452043vassalages
visages1138693vis_ages
wastages12109753wastages

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.1731032896.0
2DLD Change Limit1461621028.53017135.1
3Display Results1021020.0931096.8
 (SQL Overall)1786911028.79620315.0
 
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.