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

98 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
leafage119457(None) 
leafages1244621leafages
leakage1235001leakage
cleavage1442772cleavage
lavage1038262l_avage
leakages1334932leakages
serfage1138402serfage
adage7414053__adage
apanage1036803apanage
breakage1544183breakage
cleavages1542863cleavages
damage10410773_damage
dealate83617843dealate
deface123113863de_face
defame123212433de_fame
degage92711383de_gage
drayage1234423drayage
efface14366673_efface
encage93713503_encage
enface112510353_enface
engage82812103_engage
enrage72715073_enrage
fleabag1342923fleabag_
fleabags1442283fleabags
fleabane1343633fleabane
floatage1244403floatage
garage8314513_garage
gavage1137193_gavage
graftage1343683graftage
herbage1337003herbage
keelage1236183keelage
laager74312783l_a_ager
lanate6421263l_anate
large65325463l_a_rge
lasagne844063l_asagne
lavages1138603l_avages
leachate1347443leachate
leaf76441033leaf___
leafed105713873leaf_ed
leafier10329833leafier
leafing113313583leafing
leaflet10199743leaflet
leaflike1534713leaflike
leafs85721183leaf__s
leafy116316213leaf__y
league758743lea_gue
leasable101510133leasable
lease55230263le__ase
leave84723723le__ave
ledge76519473le__dge
legate72917453le_gate
leverage1285393leverage
linage7713403l_inage
lineage878983lineage
linkage1295963linkage
lockage1436613lockage
lovage1037353l_ovage
luggage1043673luggage
manage93818903_manage
meltage1037953meltage
menage93216543me_nage
message1037833message
metage93114453me_tage
peage84723563pe__age
peerage1089803peerage
pelage9515363pe_lage
peonage1048723peonage
quayage2044573quayage
ravage1039303_ravage
reawake14457893reawake
redamage1244193redamage
reface113616353re_face
refuge105312613re_fuge
reimage1037913reimage
restage83316193restage
savage10410173_savage
scalage103110533scalage
seabag938473seabag_
seabags1037483seabags
seafarer1144843seafarer
seaware1049623seaware
seepage1037543seepage
selvage1136553selvage
septage1078403septage
serfages1238233serfages
sewage10310733se_wage
soakage1236103soakage
stealage946583stealage
teacake1335453teacake
teaware1048143teaware
teenage8108053teenage
tentage81010643tentage
thanage11117943thanage
ventage11109623ventage
waftage14115323_waftage
webpage1543133webpage
welfare1335713welfare
wharfage1842213wharfage

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.1401276364.3
2DLD Change Limit134027987.14318763.4
3Display Results98980.0432279.1
 (SQL Overall)178691987.32624391.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.