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

147 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
elegises912882(None) 
elegies81312901elegi_es
elegise8139391elegise_
elegised10145921elegised
elegists9128111elegists
elegizes18137101elegizes
aegises8311372_aegises
clevises1336902clevises
ecesises1037022ecesises
egises7312492__egises
elegiacs1144052elegiacs
elegist81311972elegis_t
elegits8149342elegi_ts
elegize17127382elegize_
elegized19145682elegized
energises1047062energises
eulogises1045682eulogises
exegeses1644212exegeses
legists899592_legists
lewises1039132_lewises
televises1246352televises
alewives1444283alewives
alexines15258503alexines
betises94816123_betises
blemishes1665083blemishes
blesses93812393ble_sses
brewises1337213brewises
celeries10316313celeri_es
cerises94722253_cerises
chemises153211983chemises
cleanses10358143cleanses
clergies1137903clergi_es
clerisies1147253clerisies
degases93413103_degases
delegates1139843delegates
demises103719563_demises
devises114116763_devises
ebonises1039223ebonises
eclogites1245263eclogites
eisegeses1042903eisegeses
elapses957663el_apses
elatives1139783elatives
electees10238723electees
electives1448923electives
elegances1246183elegances
elegiac1045453elegi_ac
elegising1145423elegising
elegit71212893elegi__t
elemis8312383elemi__s
elevates111110423elevates
elevenses1244333elevenses
elides74420693el__ides
eligibles12113063eligibles
elites66027123el__ites
elitisms1048193elitisms
elitists848543elitists
ellipses1044343ellipses
emeries91620023emeri_es
emeses86114963eme__ses
emetines10611053emetines
emprises12311003emprises
enemies9313693enemi_es
energies9310783energi_es
energise947333energise_
energised1145183energised
energizes1945473energizes
engines81114463e_ngines
enosises8311003enosises
epeeists1044793epeeists
eremites10312603eremites
eserines8413743eserines
eternises9119453eternises
eulogies938523eulogi_es
eulogise945643eulogise_
eulogised1143733eulogised
eulogists1046653eulogists
eulogizes1945593eulogizes
excises1638933e_xcises
exegesis1643643exegesis
exegetes1655313exegetes
exercises1846463exercises
flemishes1765243flemishes
flenses1039473fle_nses
glacises1138503glacises
glegness1034613glegness
haggises1335883haggises
ileuses738673ile_uses
itemises1087693itemises
lapises93513463_lapises
leases65428113_le_ases
legalises1038563_legalises
legates82917683_legates
leges64427283_leg__es
legions84611783_legions
legist71315253_legis_t
legits71313003_legi_ts
legless838013_legless
legumes1036633_legumes
lenites7818443_lenites
lenses64620893_le_nses
leses54930813_le__ses
levies93919863_levi_es
liaises7311053_liaises
ligases82310713_ligases
lorises73918593_lorises
melodises1247603melodises
merises93421423_merises
neguses837933_neguses
noesises838503noesises
obelises1039103obelises
olefines1137323olefines
oleines7313393ole_ines
ologies8615023ologi_es
ologists939443ologists
peises84125043_pe_ises
pelerines11311843pelerines
pelletises1246343pelletises
pelvises1337273pel_vises
penises9318193_penises
pleases94515483ple_ases
plenishes1487083plenishes
plenisms1237963plenisms
plenists1038253plenists
plexuses1734113plexuses
poetises10313953poetises
precises123218333precises
premises123018273premises
previses133814283previses
regimes104514743_regimes
regives115014213_regives
releases8313343rele_ases
relegates10310943relegates
remises93423483_remises
rerises73525883_rerises
revises104220533_revises
seises64026713_se_ises
selenides10178193selenides
selenites91312083selenites
selenoses947463selenoses
semises93916553_semises
solecises1189103solecises
speises93813933spe_ises
teleses7313123tele__ses
televise1146063televise_
televised1344243televised
ulexites1534943ulexites
vegies104314273_vegi_es

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621476.33023090.4
3Display Results1471470.0602450.0
 (SQL Overall)1786911476.54627297.7
 
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.