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 “bowlful” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

60 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
bowlful154461(None) 
bowlfuls1642741bowlfuls
boatful1236282boatful
bookful1644762bookful
boxful18145272bo_xful
soulful1045292soulful
toilful1044812toilful
awful1178143_aw_ful
bagful1237213b_agful
bagsful1344893bagsful
baleful1237993baleful
baneful1237893baneful
bashful1556553bashful
bellyful1642513bellyful
boastful1344853boastful
boatfuls1344823boatfuls
boll65634753bo_l__l
bolus79125543bo_l_us
bookfuls1743453bookfuls
bottleful1452373bottleful
bowel105621203bow__el
bowfin14338353bow_fin
bowl96827703bow___l
bowlder13407473bowlder
bowled125018133bowl_ed
bowleg12369173bowl_eg
bowlegs13366813bowlegs
bowler114217313bowl_er
bowlers123715783bowlers
bowless123310313bowless
bowlike16349473bowlike
bowline123613113bowline
bowling133916493bowling
bowls106121433bowl__s
boxfuls19113603bo_xfuls
boxhaul1943013boxhaul
brimful1443883brimful
bulbul10348073b_ulbul
doleful1146333doleful
doomful1343663doomful
forkful1744773forkful
formful1545183formful
hopeful1545903hopeful
joyful1943843jo_yful
lawful1235493law_ful
moanful12105003moanful
pailful1236103pailful
potful1138083po_tful
poutful1236743poutful
powerful1653243powerful
roomful1244183roomful
skilful1443933skilful
sobful1136333so_bful
songful1145163songful
topful1136543to_pful
wailful1344953wailful
wilful1235963_wilful
willful1344533willful
woeful1236363wo_eful
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 Filter1786911340270.1561145455.1
2DLD Change Limit134027606.29621287.6
3Display Results60600.0163750.0
 (SQL Overall)178691606.46827626.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.