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

149 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
tubful113668(None) 
tubfuls1245481tubfuls
cupful1356422cupful
jugful1734602jugful
mugful1235402mugful
rueful948202rueful
sobful1136332sobful
tinful938042tinful
topful1136542topful
tubal75517202tub_al
tubule839852tub_ule
tuneful1046122tuneful
aidful1057073aidful
aimful1166703aimful
armful1167163armful
artful968273artful
awful1178143_awful
babul96317713bab_ul
bagful1237213bagful
boxful18145273boxful
bubal94218213bub_al
bubu85022673bub_u_
bubus95115453bub_us
bulbul10348073bulbul
canful11610263canful
capful1368173capful
carful11610973carful
cupfuls1444343cupfuls
cupsful1453433cupsful
doubtful1442943doubtful
duffel13407753duffel
dufus94010813du_fus
dutiful1144763dutiful
earful958963earful
eyeful1235903eyeful
fitful1256333fitful
fulfil1246423fulfil
furfur1235553furfur
hatful12108743hatful
hubbub1243603hubbub
hurtful1344853hurtful
hushful1644333hushful
ireful948713ireful
jarful1646683jarful
joyful1943843joyful
jugfuls1843063jugfuls
jugsful1842683jugsful
lapful1156483lapful
lawful1235493lawful
lungful1144013lungful
lustful1045283lustful
manful11610213manful
mugfuls1344003mugfuls
museful1245883museful
panful1179743panful
potful1138083potful
poutful1236743poutful
pushful1544493pushful
rubel75416833rub_el
rubout8313563rubout
rubus76415063rub_us
ruthful1344503ruthful
sinful938803sinful
soulful1045293soulful
subcult1149603subcult
subdual10126713subdual
subdue9128493subdue
subfile122010503subfile
subfix1835073subfix
subfusc1444333subfusc
subgum1136133subgum
subrule939643subrule
sulfur937913sulfur
tableful1344183tableful
tabouli945843tabouli
tabour84011323tabour
tabu66328493tab_u_
tabuli839363tab_uli
tabun75914373tab_un
tabus74820923tab_us
tactful1236163tactful
tankful1445163tankful
tearful1046033tearful
teenful1045563teenful
tibial849843tibial
tinfuls1036593tinfuls
tofu76921333t_ofu_
tofus86415423t_ofus
toilful1044813toilful
topfull1244153topfull
trayful1344583trayful
truckful1743073truckful
trunkful1542893trunkful
trustful1144373trustful
truthful1443363truthful
tub55640033tub___
tuba65422363tub__a
tubae74716643tub_ae
tubas75119583tub_as
tubate82813173tubate
tubbed114712223tubbed
tubber104313203tubber
tubby124511403tub_by
tube65828663tub__e
tubed85818043tub_ed
tuber75420683tub_er
tubers85017033tubers
tubes74826453tub_es
tubifex1942063tubifex
tubing93813093tubing
tubist83013163tubist
tubs65430063tub__s
tubular9267473tub_ular
tubules9310233tub_ules
tubulin9116433tub_ulin
tuchun1145443tuchun
tufa75016613tu_f_a
tufas85314383tu_fas
tuff104528523tu_f_f
tuffet122612083tuffet
tuffs115118263tu_ffs
tufoli933973tu_foli
tuft76929513tu_f_t
tufts85713273tu_fts
tufty114810413tu_fty
tumbrel11406853tumbrel
tumbril11256403tumbril
tumour8137403tumour
tumuli835933tu_muli
tumult839703tu_mult
tuneup835203tuneup
tunnel64310633tunnel
tuque14469193tu_que
turf75334053turf__
turfed103110963turfed
turfs84620443turf_s
turfy114315403turf_y
turnup835093turnup
tussal6288323tussal
tussur6357293tussur
tutu48423173tu_tu_
tutus55214813tu_tus
unfurl937953_unfurl
useful947013useful
vatful12107083vatful
waeful1238123waeful
wilful1235963wilful
woeful1236363woeful
woful1158173_woful

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 Filter1786911127160.390458182.1
2DLD Change Limit1127161495.65619928.6
3Display Results1491490.0463239.1
 (SQL Overall)1786911496.09229332.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.