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 “cageful” 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
cageful135648(None) 
cagefuls1484341cagefuls
careful1249111careful
pageful1346351pageful
bagful1237212bag_ful
bagsful1344892bagsful
baleful1238002baleful
baneful1237892baneful
canful11610262ca_nful
cansful1236832cansful
capful1368172ca_pful
carful11610972ca_rful
changeful1842592changeful
dareful1157052dareful
easeful1037292easeful
fateful1397512fateful
hateful13107682hateful
pagefuls1474342pagefuls
stageful1244452stageful
waeful1238122wa_eful
wakeful1735612wakeful
wameful1535672wameful
aidful1057073_aidful
aimful1166703_aimful
armful1167163_armful
artful968273_artful
awful1178143_a_wful
bagel85116793bage__l
bagfuls1334753bag_fuls
bashful1556553bashful
blameful1543813blameful
caecal103713733ca_ecal
caecum1238183ca_ecum
cage75339063cage___
caged95426363cage__d
cager85229223cage__r
cagers95624193cage_rs
cages85936013cage__s
cagey115917823cage__y
cajeput1845053cajeput
camel96822803came__l
cameral11311283cameral
canfuls1248423ca_nfuls
capfuls1436523ca_pfuls
caracul1138823caracul
carefully1745083carefully
carfuls1249133ca_rfuls
casefy1436273casef_y
caseous9312513caseous
caul65630003ca___ul
chanceful1942763chanceful
cheekful2042823cheekful
cheerful1643983cheerful
cupful1356423c_upful
cupsful1453433cupsful
direful1156613direful
dirgeful1343253dirgeful
doleful1146333doleful
earful958963ea_rful
eyeful1235903_eyeful
factful1536373factful
gainful1145833gainful
gleeful1144323gleeful
graceful1445393graceful
grateful1245403grateful
handful14127253handful
harmful1535763harmful
hasteful14105253hasteful
hatful12108743ha_tful
hatsful13106193hatsful
hopeful1545903hopeful
ireful948713_ireful
jarful1646683ja_rful
jarsful1744603jarsful
jugful1734603jug_ful
jugsful1842683jugsful
ladleful1243283ladleful
lapful1156483la_pful
lawful1235493la_wful
lifeful1344613lifeful
manful11610213ma_nful
mugful1235403mug_ful
museful1245883museful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panful1179743pa_nful
peaceful1545463peaceful
pipeful1445643pipeful
plateful1345433plateful
rackful1645873rackful
rueful948203_rueful
sackful1645353sackful
shameful1644283shameful
spadeful1443963spadeful
stagefuls1343293stagefuls
tableful1344183tableful
tactful1236163tactful
tankful1445163tankful
tasteful11115223tasteful
tuneful1046123tuneful
useful947013_useful
vatful12107083va_tful
vengeful1542873vengeful
wailful1344953wailful
wamefuls1643863wamefuls
wasteful14104933wasteful
woeful1236363_woeful

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271085.89022755.0
3Display Results1081080.0303600.0
 (SQL Overall)1786911086.32628247.1
 
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.