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

114 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
lapfuls123450(None) 
capfuls1436531capfuls
lapful1156481lapful_
bagfuls1334752bagfuls
canfuls1248422canfuls
capful1368182capful_
carfuls1249132carfuls
cupfuls1444342cupfuls
earfuls1036862earfuls
hatfuls1386022hatfuls
jarfuls1754772jarfuls
lapels83712042lap_els
lapsus8437272lapsu_s
lawful1235492lawful_
panfuls1237182panfuls
vatfuls1384852vatfuls
alphyls15113953alphyls
ampuls1098893_ampuls
annuls64711733_annuls
appals104812943_appals
appels104312793_appels
appulse1134673_appulse
armfuls1275013armfuls
awful1178143_awful_
babuls105413643ba_buls
bagful1237213bagful_
boatfuls1344823boatfuls
boxfuls19113603boxfuls
cagefuls1484343cagefuls
canful11610263canful_
capsule1137353capsule
capsules1236633capsules
carful11610973carful_
cauls75727773ca__uls
cupful1356423cupful_
earful958963earful_
eyefuls1343843eyefuls
farfals13268503farfals
farfels13348213farfels
glassfuls13122813glassfuls
hamauls12387823hamauls
handfuls15115753handfuls
hatful12108743hatful_
hauls86123733ha__uls
headfuls1544313headfuls
hopefuls1644073hopefuls
jarful1646683jarful_
jugfuls1843063jugfuls
labels84515683la_bels
labials9299873labials
labours9349893labours
labrums1175853labrums
ladlefuls1342133ladlefuls
lalls55324133la__lls
langues81211913langues
langurs889103langurs
lapdogs1134073lapdogs
lapel73716683lap_el_
lapides103012043lapides
lapilli945643lapilli
lapillus1043933lapillus
lapins84520683lap_ins
lapis76223153lap__is
lapises93513463lapises
lappers113717463lappers
lappets11329133lappets
laps66848873lap___s
lapsers93911053lapsers
lapses85217693lap_ses
laptops1166603laptops
larrups934733larrups
larums83610533la_rums
lauds65618483la__uds
laurels746663laurels
lawfully1743503lawfully
layouts1046483layouts
layups1133993la_yups
lazuli1535363la_zuli
lazulis1634903la_zulis
lungfuls1242773lungfuls
lupous849433lupou_s
lupus74512523lup_u_s
manful11610213manful_
mauls76524953ma__uls
mugfuls1344003mugfuls
pagefuls1474343pagefuls
pailfuls1343853pailfuls
palmfuls1543473palmfuls
panful1179743panful_
pappus9408373pappu_s
papula103011123pap_ula
papule102212133pap_ule
papules112411573pap_ules
pipefuls1543753pipefuls
platefuls1443963platefuls
playful1544653playful_
potfuls1236293potfuls
puls65437563__p_uls
rackfuls1744643rackfuls
rappels11448803rappels
sackfuls1744163sackfuls
sapours93610623sapours
sauls55128123sa__uls
tankfuls1543803tankfuls
tinfuls1036593tinfuls
topful1136543topful_
topfull1244153topfull
trayfuls1443483trayfuls
tubfuls1245483tubfuls
vapours12277463vapours
vatful12107083vatful_
waeful1238123waeful_
wamefuls1643873wamefuls
wauls86120553wa__uls

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 Limit1340271146.97019229.1
3Display Results1141140.0303800.0
 (SQL Overall)1786911147.40624127.9
 
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.