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

114 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
ingresses103853(None) 
aggresses1146142aggresses
ancresses1138412ancresses
congresses1348022congresses
digresses1137862digresses
egresses949442_egresses
engrosses1045472engrosses
impresses1338212impresses
increases1157382increases
incrosses1146032incrosses
ingress838652ingre_s_s
ingressives1554252ingressives
ogresses938472_ogresses
pingrasses1343962pingrasses
regresses10310462regresses
tigresses1046402tigresses
undresses1039312undresses
actresses1137933actresses
addresses1165633addresses
aggressed1244203aggressed
angrinesses1247283angrinesses
anureses837973anure_ses
bignesses1267963bignesses
burgesses1245513burgesses
caresses10314063_caresses
congressed1445463congressed
cresses94219813__cresses
cypresses1645853cypresses
degreases1146153degreases
depresses1259883depresses
digressed1245613digressed
dinginesses1337473dinginesses
distresses1148853distresses
dresses83716173__dresses
duresses939173_duresses
egressed1046873_egressed
eldresses1045673eldresses
empresses1348163empresses
engrossed1144313engrossed
engrosser1043843engrosser
engrossers1143093engrossers
enureses838113enure_ses
enuresises1043923enuresises
expresses1837863expresses
finenesses13310713finenesses
finesses111912343fin__esses
grasses84117343__grasses
greases84816713__greases
grosses84517683__grosses
guesses8169373__guesses
heiresses1236963heiresses
huntresses1345283huntresses
icinesses11310073icinesses
idlesses936003i_dlesses
illnesses937283illnesses
impreses1238093impre_ses
impressed1446283impressed
incenses102411003in_censes
increase1066453increase_
increased1245533increased
increaser1154573increaser
increasers1243313increasers
incrossed1244743incrossed
inertnesses1198723inertnesses
ingenues947103ing_enues
ingested10259003ing_ested
ingests83210983ing_e_sts
ingrates9514173ingr_ates
ingression1145513ingression
ingressions1245493ingressions
ingressive1455263ingressive
inkinesses1439423inkinesses
inmeshes1345613in_meshes
innernesses1146733innernesses
inrushes1136273in_rushes
invernesses1447033invernesses
inverses112410983in_verses
jointresses1843473jointresses
kindnesses1537213kindnesses
largesses10246273largesses
longnesses1138503longnesses
minidresses1443283minidresses
misguesses1343323misguesses
mistresses1247993mistresses
nesses64718323_n__esses
nighnesses1446463nighnesses
onenesses9311823onenesses
oppresses1346873oppresses
peeresses1138473peeresses
pinknesses1636583pinknesses
presses93523153__presses
progresses1347493progresses
redresses10410293redresses
regressed1138113regressed
represses11412143represses
ribgrasses1342943ribgrasses
ringtosses1142763ringtosses
seeresses939053seeresses
snugnesses1165423snugnesses
stresses81112493_stresses
sundresses1146543sundresses
tendresses1145923tendresses
thingnesses1545193thingnesses
tininesses10311163tininesses
tresses73719543__tresses
uncrosses1146153uncrosses
undressed1138343undressed
ungreased1136333ungreased
unpressed1237953unpressed
unstresses1046033unstresses
untrusses945703untrusses
victresses1544973victresses
votresses1236503votresses
winepresses1643463winepresses

Search took 7 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.406440125.6
2DLD Change Limit1486411146.03024650.2
3Display Results1141140.0462478.3
 (SQL Overall)1786911146.48227567.3
 
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.