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

122 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
boxful1814527(None) 
boxfuls19113601boxfuls
bagful1237212bagful
boatful1236282boatful
bookful1644762bookful
bowlful1544612bowlful
boxhaul1943012boxhaul
joyful1943842joyful
potful1138082potful
sobful1136332sobful
topful1136542topful
woeful1236362woeful
woful1158172wo_ful
aidful1057073aidful
aimful1166703aimful
armful1167163armful
artful968273artful
awful1178143_awful
babul96317713b_abul
bagfuls1334753bagfuls
bagsful1344893bagsful
baleful1237993baleful
baneful1237893baneful
bashful1556553bashful
befoul1137253befoul
biofuel1243293biofuel
boastful1344853boastful
boatel84314093boatel
boatfuls1344823boatfuls
boff124727323bo_f_f
boffed15369483boffed
boffin14359053boffin
boffo136010373bo_ffo
boffola1543463boffola
boffos14568193boffos
boffs134915503bo_ffs
bogus85616473bo_gus
boil66335183bo__il
boll65634753bo__ll
bolus79125543bo_lus
bonduc1136603bonduc
bonus75324323bo_nus
boojum1733843boojum
bookfuls1743453bookfuls
boral75831703bo_ral
bordel94514573bordel
boreal84817213boreal
bosque17257733bosque
bosun75113593bo_sun
botel75121863bo_tel
botfly1436093botfly
bouffe14438313bouffe
boule74828043bo__ule
bout66353293bo__ut
bowel105621203bo_wel
bowfin14338353bowfin
bowl96827703bo__wl
bowlfuls1642743bowlfuls
box1210142343box___
boxball18155323boxball
boxcar1734753boxcar
boxed154318613box_ed
boxer145016523box_er
boxers155013483boxers
boxes145625073box_es
boxfish2285543boxfish
boxhauls2042073boxhauls
boxier154311743boxier
boxily1877843boxily
boxing163915153boxing
boxy166420733box__y
brimful1443883brimful
bulbul10348073bulbul
canful11610263canful
capful1368173capful
carful11610973carful
consul82312303consul
coxal146116673cox_al
cupful1356423cupful
doleful1146333doleful
doofus1036163doofus
doomful1343663doomful
earful958963earful
eyeful1235903eyeful
fitful1256333fitful
forkful1744773forkful
formful1545183formful
foul77027583fo__ul
hatful12108743hatful
hopeful1545903hopeful
ireful948713ireful
jarful1646683jarful
jugful1734603jugful
lapful1156483lapful
lawful1235493lawful
manful11610213manful
moanful12105003moanful
moghul1244473moghul
mogul8310213mo_gul
mugful1235403mugful
nonfuel1045733nonfuel
odorful1143483odorful
offal1136243_offal
panful1179743panful
potfuls1236293potfuls
poutful1236743poutful
roomful1244183roomful
rueful948203rueful
sinful938803sinful
songful1145163songful
soul46435713so__ul
soulful1045293soulful
tinful938043tinful
tofu76921333to_fu_
tofus86415423to_fus
toilful1044813toilful
topfull1244153topfull
tubful1136683tubful
useful947013useful
vatful12107083vatful
waeful1238123waeful
wilful1235963wilful

Search took 9 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.1401276364.3
2DLD Change Limit1127161228.07613956.9
3Display Results1221220.0961270.8
 (SQL Overall)1786911228.31221498.0
 
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.