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

102 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
tubfuls124548(None) 
tubful1136681tubful_
cupfuls1444342cupfuls
jugfuls1843062jugfuls
mugfuls1344002mugfuls
tinfuls1036592tinfuls
tubule839852tub_ule
tubules9310232tub_ules
armfuls1275013armfuls
babuls105413643bab_uls
bagfuls1334753bagfuls
boxfuls19113603boxfuls
bubals103513843bub_als
bubus95115453bub_u_s
bulbuls11346783bulbuls
canfuls1248423canfuls
capfuls1436523capfuls
carfuls1249133carfuls
cupful1356423cupful_
duffels14296453duffels
dufus94010813du_fu_s
earfuls1036863earfuls
eyefuls1343843eyefuls
fulfils1345723fulfils
hatfuls1386023hatfuls
hubbubs1342603hubbubs
jarfuls1754773jarfuls
jugful1734603jugful_
lapfuls1234503lapfuls
lungfuls1242773lungfuls
mugful1235403mugful_
panfuls1237173panfuls
potfuls1236293potfuls
rubels84112993rub_els
rubouts937983rubouts
rubus76415063rub_u_s
rueful948203rueful_
sobful1136333sobful_
subcult1149603subcult
subcults1246933subcults
subduals1156293subduals
subdues1099893subdues
subfile122010503subfile
subfiles131710723subfiles
subfusc1444333subfusc
subfuscs1543753subfuscs
subgums1235893subgums
subrule939643subrule
subrules1039723subrules
sulfurs1037343sulfurs
tablefuls1443223tablefuls
tabouli945843tabouli
taboulis1045043taboulis
tabours94110093tabours
tabuli839363tab_uli
tabulis938833tab_ulis
tabuns8489223tab_uns
tabus74820923tab_u_s
tankfuls1543803tankfuls
tinful938043tinful_
tofus86415423t_ofu_s
topful1136543topful_
topfull1244153topfull
trayfuls1443483trayfuls
truckfuls1842463truckfuls
trunkfuls16112283trunkfuls
tubal75517203tub_al_
tubas75119583tub__as
tubbers113411253tubbers
tubers85017033tub_ers
tubes74826453tub__es
tubings10336483tubings
tubists9288323tubists
tubs65430063tub___s
tubular9267473tub_ular
tubulin9116433tub_ulin
tubulins10106293tub_ulins
tubulose1043893tub_ulose
tubulous1045373tub_ulous
tuchuns1233983tuchuns
tufas85314383tu_f_as
tuffets13266523tuffets
tuffs115118263tu_f_fs
tufoli933973tu_foli
tufts85713273tu_f_ts
tumbrels12285733tumbrels
tumbrils12255373tumbrils
tumours976753tumours
tumuli835933tu_muli
tumult839703tu_mult
tumults934823tu_mults
tumulus935033tu_mulus
tuneful1046123tuneful_
tuneups933333tuneups
tunnels7328723tunnels
tuques15358373tu_ques
turfs84620443turf__s
turnups933893turnups
tussurs7356393tussurs
tutus55214813tu_tu_s
unfurls1035573_unfurls
vatfuls1384853vatfuls

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.423422437.4
2DLD Change Limit1340271026.64020184.8
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.10925135.9
 
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.