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

104 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
vatfuls138485(None) 
hatfuls1386021hatfuls
vatful12107081vatful_
bagfuls1334752bagfuls
boatfuls1344822boatfuls
canfuls1248422canfuls
capfuls1436522capfuls
carfuls1249132carfuls
earfuls1036862earfuls
hatful12108742hatful_
jarfuls1754772jarfuls
lapfuls1234502lapfuls
panfuls1237172panfuls
potfuls1236292potfuls
vatus86114642vat_u_s
ampuls1098893_ampuls
annuls64711733_annuls
armfuls1275013armfuls
artful968273artful_
atolls65511353_atolls
awful1178143_awful_
babuls105413643ba_buls
bagful1237213bagful_
batfowls1642773batfowls
battues94610193battues
boatful1236283boatful_
boxfuls19113603boxfuls
cagefuls1484343cagefuls
canful11610263canful_
capful1368173capful_
carful11610973carful_
catfall1237393catfall
catfalls1347063catfalls
catguts1045313catguts
catsups1135333catsups
cauls75727773ca__uls
cupfuls1444343cupfuls
datums936353dat_ums
earful958963earful_
eyefuls1343843eyefuls
factful1536373factful_
faithfuls1842303faithfuls
farfals13268503farfals
farfels13348213farfels
fateful1397513fateful_
fistfuls1454563fistfuls
fitful1256333fitful_
hamauls12387803hamauls
handfuls15115753handfuls
hateful13107683hateful_
hatsful13106193hatsful_
hauls86123733ha__uls
headfuls1544313headfuls
jarful1646683jarful_
jugfuls1843063jugfuls
kistfuls1553833kistfuls
lapful1156483lapful_
lawful1235493lawful_
manful11610213manful_
mauls76524953ma__uls
mugfuls1344003mugfuls
pagefuls1474343pagefuls
pailfuls1343843pailfuls
palmfuls1543473palmfuls
panful1179743panful_
patrols93513513patrols
platefuls1443963platefuls
potful1138083potful_
rackfuls1744643rackfuls
ratals64219583rat_als
ratels64518213rat_els
sackfuls1744163sackfuls
sauls55128123sa__uls
tactful1236163tactful_
tankfuls1543803tankfuls
tinfuls1036593tinfuls
trayfuls1443473trayfuls
tubfuls1245473tubfuls
vacuums1443403vacuums
vagus96713813va_gu_s
vails85825933va__ils
vakeels14113733vakeels
vakils1337593va_kils
valgus1047103valgu_s
valours10248733valours
values94314943va_lues
valvula1343253valvula
valvule1343663valvule
valvules1443473valvules
vandals113211663vandals
vapours12277453vapours
varus85921183va_ru_s
vascula1245853vascula
vassals1057953vassals
vats76841743vat___s
vatu76524333vat_u__
vault85823763va__ult
vaults94511673va__ults
vauntful1442473vauntful_
vaus75928923va__u_s
vitals94514303vit_als
waeful1238123waeful_
wamefuls1643863wamefuls
wauls86120553wa__uls

Search took 10 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.1531167915.0
2DLD Change Limit1340271048.81315207.9
3Display Results1041040.0801300.0
 (SQL Overall)1786911049.04619753.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.