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

90 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
largesses1024627(None) 
largesse9294411largesse_
burgesses1245512burgesses
caresses10314062car_esses
farnesses122310812farnesses
harnesses121812072harnesses
largeness1038272largeness
largenesses1247552largenesses
largess8408912large_s_s
laxnesses1646632laxnesses
abbesses1235333_abbesses
accesses1287493_accesses
aggresses1146143_aggresses
argosies939523_argosies
arguses84711743_arg_uses
assesses737383_assesses
avgasses1284193_avgasses
badnesses1239253badnesses
bagasses1136313ba_gasses
barenesses12311703barenesses
bargees105415873barge__es
baronesses1238913baronesses
carcasses1337483carcasses
caressed1139163car_essed
caresser1038813car_esser
caressers1137443car_essers
clearnesses13106153clearnesses
cresses94219813_cr_esses
darknesses1537013darknesses
dearnesses1139583dearnesses
digresses1137863digresses
dresses83716173_dr_esses
duresses939173dur_esses
egresses949443egr_esses
eldresses1045673eldr_esses
fairnesses1357383fairnesses
fatnesses121710463fatnesses
flatnesses1337763flatnesses
gaynesses1336563gaynesses
gladnesses1236683gladnesses
glarinesses1239513glarinesses
harasses11311033har_asses
hardasses1346453hardasses
hardnesses141810543hardnesses
harnessed13186193harnessed
ingresses1038533ingresses
karosses1236493kar_osses
kermesses15284963kermesses
kirmesses15253903kirmesses
lacinesses12312123lacinesses
lacrosses1145313lacrosses
lamenesses12610563lamenesses
lamperses1345123lamperses
lanknesses1437503lanknesses
larcenies1147533larcenies
larees65323113lar_e__es
larges74824233larg___es
largest83715103large_s_t
larkinesses1538993larkinesses
lasses64827593la___sses
latenesses10413363latenesses
lazinesses19310153lazinesses
leannesses10108343leannesses
lionesses939433lionesses
loesses7310033l__oesses
longnesses1138503longnesses
lornnesses1037823lornnesses
lownesses1236983lownesses
madnesses1239833madnesses
marquesses2143353marquesses
nearnesses1039103nearnesses
ogresses938473ogr_esses
pareses94718883par_e_ses
patnesses111611793patnesses
presses93523153_pr_esses
rarenesses10313113rarenesses
rawnesses1288123rawnesses
regresses10310463regresses
sadnesses10310303sadnesses
sargassos1042323sargassos
stresses81112493str_esses
tartnesses101110713tartnesses
teargasses1143063teargasses
tigresses1046403tigresses
tresses73719543_tr_esses
waenesses1239773waenesses
wannesses1239233wannesses
wardresses1445413wardresses
warinesses131514523warinesses
warmnesses15167353warmnesses

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 Filter1786911486410.420425454.8
2DLD Change Limit148641907.41020059.5
3Display Results90900.0461956.5
 (SQL Overall)178691907.87622688.0
 
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.