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

62 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
eyefuls134384(None) 
eyeful1235901eyeful_
earfuls1036862earfuls
eyecups1442822eyecups
eyefold1443342eyefold
eyefolds1542622eyefolds
armfuls1275013armfuls
bagfuls1334753bagfuls
befouls1236053_befouls
boxfuls19113603boxfuls
cagefuls1484343cagefuls
canfuls1248423canfuls
capfuls1436523capfuls
carfuls1249133carfuls
cupfuls1444343cupfuls
defuels11296983_defuels
earful958963earful_
easeful1037293easeful_
eels46536743e_e__ls
emeus76913333eme_u_s
ensouls736033ensouls
eyeable1239063eyeable
eyeball1245063eyeball
eyeballs1344213eyeballs
eyebars1245333eyebars
eyebolt1246363eyebolt
eyebolts1343483eyebolts
eyecup1344493eyecu_p
eyehole1346003eyehole
eyeholes1445593eyeholes
eyeless1058053eyeless
eyelets1057523eyelets
eyelids1135943eyelids
eyers86521333eye__rs
eyes75837883eye___s
hatfuls1386023hatfuls
headfuls1544313headfuls
hopefuls1644073hopefuls
ireful948713ireful_
jarfuls1754773jarfuls
jugfuls1843063jugfuls
lapfuls1234503lapfuls
mugfuls1344003mugfuls
needfuls1242403needfuls
pagefuls1474343pagefuls
panfuls1237173panfuls
peepuls1134923peepuls
pipefuls1543753pipefuls
potfuls1236293potfuls
refels94618053_refels
refuels10399523_refuels
rueful948203rueful_
synfuels1441903synfuels
tinfuls1036593tinfuls
tubfuls1245483tubfuls
useful947013useful_
vatfuls1384853vatfuls
waeful1238123waeful_
wamefuls1643873wamefuls
woeful1236363woeful_
yells85821943_ye_lls
yeuks125110093_ye_uks

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.406440125.6
2DLD Change Limit134027627.00319138.5
3Display Results62620.0134769.2
 (SQL Overall)178691627.42224075.9
 
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.