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

71 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
webpage154313(None) 
webpages1643051webpages
seepage1037542seepage
warpage1336402warpage
ambage11510593amb_age
bespake15436963bespake
cabbage1446983cabbage
creepage1344343creepage
cubage1178273cub_age
debag94212303deb_ag_
debags104211063deb_ags
debase94014473deb_ase
debate94419193deb_ate
degage92711383de_gage
empale102611263_empale
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
herbage1337003herbage
keelage1236183keelage
leafage1194573leafage
leakage1235003leakage
meltage1037953meltage
menage93216543me_nage
message1037833message
metage93114453me_tage
mispage12310523mispage
page76036103___page
peage84723563pe__age
peerage1089803peerage
pelage9515363pe_lage
peonage1048723peonage
pipage1199143_pipage
rampage1237453rampage
rebate84424103reb_ate
reimage1037913reimage
repave114813873re_pave
respace11310913respace
respade1039573respade
restage83316183restage
seepages1137283seepages
selvage1136553selvage
septage1078403septage
serfage1138403serfage
sewage10310733se_wage
teenage8108053teenage
tentage81010643tentage
umbrage1236723umbrage
ventage11109623ventage
verbiage1444543verbiage
waftage14115323waftage
wage84834083w___age
wantage11119623wantage
warpages1437053warpages
wastage11109253wastage
wattage1186983wattage
weave115218533we__ave
webcam1545543webca_m
webcams1643073webcams
webcast1445553webcast
weblike1635923weblike
weblog1234223weblog_
weblogs1334223weblogs
website1235323website
wedge105215633we__dge
weepie11258793weep_ie
welfare1335713welfare
wetware1335793wetware
windage1237933windage
wordage1236503wordage
wreckage1842763wreckage

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.1561145455.1
2DLD Change Limit134027717.53017799.1
3Display Results71710.0164437.5
 (SQL Overall)178691717.70223200.6
 
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.