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

171 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
tinfuls103659(None) 
tinful938041tinful_
canfuls1248422canfuls
panfuls1237172panfuls
sinful938802sinful_
skinfuls1543092skinfuls
tankfuls1543802tankfuls
tincals93610652tincals
tinfoils1144322tinfoils
tinsels738372tinsels
trainfuls1243952trainfuls
tubfuls1245482tubfuls
aidful1057073aidful_
aimful1166703aimful_
annuls64711733_annuls
armfuls1275013armfuls
bagfuls1334753bagfuls
basinfuls1442303basinfuls
biofuels1342923biofuels
boxfuls19113603boxfuls
canful11610263canful_
capfuls1436523capfuls
carfuls1249133carfuls
cineols9128853cineols
cingula10327173cingula
cinques1837333cinques
consuls92412323consuls
cupfuls1444343cupfuls
dingus83611843dingu_s
dinkums1433673dinkums
dishfuls1554313dishfuls
earfuls1036863earfuls
eyefuls1343843eyefuls
finals94316163fin_als
finials103210153finials
fistfuls1454563fistfuls
fitful1256333fitful_
gainful1145833gainful_
gingals9109313gingals
handfuls15115753handfuls
hatfuls1386023hatfuls
incult82414773_incult
incurs83012283_incurs
incus73315053_incu_s
indols74714203_indols
indues73515263_indues
indult73614033_indult
indults8289493_indults
infall939403_infall
infalls1038943_infalls
infers93615443_infers
infill938413_infill
influx1643723_influx
infold10128163_infold
infolds11137023_infolds
infos84311673_inf_os
infuse93110573_infuse
infuses102711873_infuses
ingulf10310353_ingulf
ingulfs1134733_ingulfs
inhauls1035523_inhauls
inputs837703_inputs
inruns6359513_inruns
insouls737213_insouls
insult62813673_insult
insults7268963_insults
jarfuls1754773jarfuls
jingals1588073jingals
jugfuls1843063jugfuls
kinfolk1363603kinfolk
kinfolks1453013kinfolks
kistfuls1553833kistfuls
lapfuls1234503lapfuls
lineups934913lineups
linguals9317223linguals
lingula8428803lingula
linkups1333633linkups
lintels73311163lintels
lintols7339553lintols
linums838283lin_ums
lungfuls1242773lungfuls
manful11610213manful_
miauls8178713mi_auls
mindful1344613mindful_
miniums113910223miniums
minus75223933min_u_s
mugfuls1344003mugfuls
pailfuls1343843pailfuls
painful1246403painful_
panful1179743panful_
piculs103511753pi_culs
pineals93212853pineals
pinfold1336233pinfold
pinfolds1445143pinfolds
pinnula934923pinnula
pinnule936003pinnule
pinnules1036463pinnules
pinups1037413pin_ups
pipefuls1543753pipefuls
potfuls1236293potfuls
sinfully1445613sinfully
sinus55523853sin_u_s
skinful1444193skinful_
stickfuls1842583stickfuls
synfuels1441903synfuels
tankful1445163tankful_
teenful1045563teenful_
tenails73713923tenails
tendus75111183tendu_s
tenfold1145713tenfold
tenfolds1244413tenfolds
tenours72610073tenours
tenues63816443ten_ues
tenuis64213083ten_uis
ticals83214713ti_cals
tiffins13327983tiffins
tiffs114414883ti_f_fs
tills54631713ti__lls
tils45739613ti___ls
timbals11239533timbals
tincal83913373tincal_
tincts84510803tin_cts
tinders84219173tinders
tineal66216173tineal_
tineas64616483tin_eas
tineids8337873tineids
tines54848423tin__es
tinfoil1044633tinfoil
tinges74722343tin_ges
tingle74319073tin_gle
tingles83818323tingles
tingly103815983tin_gly
tings65329213tin__gs
tinily94014433tin_ily
tinkers113517143tinkers
tinkle103714453tin_kle
tinkles113713923tinkles
tinkly134811153tin_kly
tinners73717313tinners
tinnily1047363tinnily
tins45251303tin___s
tinsel639443tinsel_
tinters74221113tinters
tints56030923tin__ts
tirls54519803ti__rls
tissues737463tissues
titfers10318933titfers
tittups933353tittups
tofus86415423t_ofu_s
toilful1044813toilful_
tongues879693tongues
tonsils7310183tonsils
tonus56324303ton_u_s
topful1136543topful_
topfull1244153topfull
trainful1145183trainful_
trayfuls1443483trayfuls
trinkums1443413trinkums
trunkfuls16112283trunkfuls
tubful1136683tubful_
tuneful1046123tuneful_
tuneups933333tuneups
tunnels7328723tunnels
unfurls1035573_unfurls
vatfuls1384853vatfuls
vinals94716483vin_als
vincula1246403vincula
vinous93914173vinou_s
vinyls12467003vin_yls
wilful1235963wilful_
windups1334783windups

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 Limit1340271716.67020094.0
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.13925030.3
 
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.