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

108 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
willowing164532(None) 
billowing1545871billowing
pillowing1545491pillowing
wallowing1666071wallowing
allowing12369092_allowing
bellowing1547192bellowing
fallowing1666432fallowing
fellowing1655922fellowing
following1665752following
hallowing1676942hallowing
hilloaing1375432hilloaing
hilloing12158302hillo_ing
hollowing1675932hollowing
mellowing1545892mellowing
sallowing1357382sallowing
swallowing1743042swallowing
tallowing1366292tallowing
walloping1545592walloping
widowing1635182wi_dowing
willing113821612will__ing
willowier1563782willowier
willying15306712will_ying
windowing1744812windowing
winnowing1643362winnowing
yellowing1655072yellowing
alloying12339143_alloying
balloting1238393balloting
billeting1236643billeting
billing103823853bill__ing
billowier1444293billowier
blowing133813053__blowing
bolloxing1944773bolloxing
dialoging1246313dialoging
disallowing1643283disallowing
dolloping1344993dolloping
elbowing1435013_elbowing
filleting1335853filleting
filling113520803fill__ing
filliping1544233filliping
flowing143411763__flowing
followings1752823followings
galloping1356253galloping
gilling93520383gill__ing
gillying13306813gill_ying
glowing123211793__glowing
gullwing13304923gull_wing
halloaing1387033halloaing
halloing121510073hallo_ing
hallooing1366343hallooing
helloing12159123hello_ing
hilling113821773hill__ing
holloaing1385803holloaing
holloing12148823hollo_ing
hollooing1385363hollooing
hulloaing1384523hulloaing
hulloing12146703hullo_ing
hullooing1383993hullooing
illuding1035803_illuding
illuming1135873_illuming
indowing13198083_indowing
killing123118723kill__ing
lolloping1244693lolloping
lowing104623273___lowing
miaowing1434593mi_aowing
mildewing1643733mildewing
milling103223683mill__ing
nielloing1043893niello_ing
nilling83619563nill__ing
pillaging1345573pillaging
pillaring1237653pillaring
pilling103722563pill__ing
pillorying1642793pillorying
piloting1139693pi_loting
plowing133111723__plowing
reflowing1636523reflowing
reglowing1436173reglowing
replowing1537413replowing
rilling84023623rill__ing
shallowing1744113shallowing
siloing83215503si_lo_ing
slowing112814743__slowing
swilling123511933swill__ing
tillering1037883tillering
tilling83522783till__ing
twilling12268673twill__ing
upflowing1842933upflowing
walling113520973wall__ing
wallopings1652713wallopings
welcoming1743473welcoming
welling112920313well__ing
wielding13286863wiel_ding
wildering1456743wildering
wildfowling2251123wildfowling
wilding123814293wi_l_ding
wildling13248083wi_ldling
wiling103024293wi_l__ing
willow12369693willow___
willowed15156773willow_ed
willower14127463willow_er
willowers15166693willowers
willowiest1643233willowiest
willowlike2051333willowlike
willows13299753willow__s
willowy16276353willow__y
wilting113515913wi_l_ting
windrowing1843213windrowing
witling113215813witl__ing
wowing133915393w___owing

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.440406115.9
2DLD Change Limit1486411086.46622988.1
3Display Results1081080.0502160.0
 (SQL Overall)1786911086.95625688.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.