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

64 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
webpages164305(None) 
webpage1543131webpage_
seepages1137282seepages
warpages1437052warpages
ambages1269623amb_ages
cabbages1537203cabbages
creepages1444303creepages
cubages1237923cub_ages
debags104211063deb_ag_s
debases103814133deb_ases
debates103718533deb_ates
empales112411433_empales
encages103313783_encages
engages92912493_engages
enrages83114853_enrages
herbages1437093herbages
keelages1335743keelages
leafages1244623leafages
leakages1334933leakages
meltages1148243meltages
menages103615393me_nages
messages1138233messages
metages102714973me_tages
mispages13311183mispages
pages85235073___pages
peages94321853pe__ages
peerages1189893peerages
pelages10714613pe_lages
peonages1138473peonages
pipages1289423_pipages
rampages1336673rampages
rebates95123183reb_ates
reimages1138373reimages
repaves123513653re_paves
respaces12311043respaces
respades1139853respades
restages92815773restages
seepage1037543seepage_
selvages1236513selvages
septages1168263septages
serfages1238233serfages
sewages1139753se_wages
tentages91011043tentages
umbrages1336623umbrages
ventages12119773ventages
verbiages1544683verbiages
waftages15105393waftages
wages95330933w___ages
wantages12109023wantages
warpage1336403warpage_
wastages12109753wastages
wattages12106783wattages
weaves123616373we__aves
webcams1643073webca_ms
webcasts1543313webcasts
weblogs1334223weblog_s
websites1335183websites
wedges114614583we__dges
weepies122811743weep_ies
welfares1445543welfares
wetwares1445953wetwares
windages1338263windages
wordages1337053wordages
wreckages1942773wreckages

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.423422437.4
2DLD Change Limit146162646.37322934.6
3Display Results64640.0331939.4
 (SQL Overall)178691646.82926166.5
 
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.