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

80 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
forkful174477(None) 
forkfuls1843551forkfuls
forksful1842491forksful
formful1545181formful
bookful1644772bookful
forceful1644602forceful
armful1167163_armful
artful968273_artful
boatful1236283boatful
bookfuls1743463bookfuls
bowlful1544613bowlful
boxful18145273bo_xful
careful1249113careful
carful11610973car_ful
chockful2243013chockful
dareful1157053dareful
direful1156613direful
doleful1146333doleful
doomful1343663doomful
earful958963ear_ful
effortful1451413effortful
factful1536373factful
farfal123410183far_fal
farfel124310433far_fel
fateful1397513fateful
fearful1345593fearful
fistful1365903fistful
fitful1256333f_itful
forefeel14105513forefeel
forefelt14117363forefelt
foregut1149163foregut
forerun1037653forerun
forgetful1642863forgetful
fork115930943fork___
forkball1744823forkball
forked145217143fork_ed
forkedly1944323forkedly
forker134717903fork_er
forkers144615783forkers
forkier144311593forkier
forking154014843forking
forks125324683fork__s
forky156119643fork__y
formal113215203for_mal
formol112910333for_mol
formula1246293for_mula
formyl14276443for_myl
forum108318763for__um
foul77027583fo___ul
fretful1346143fretful
furfur1235553fur_fur
harmful1535763harmful
hopeful1545913hopeful
hurtful1344853hurtful
ireful948713_ireful
jarful1646683jar_ful
jarsful1744603jarsful
joyful1943843jo_yful
moanful12105003moanful
mournful1342503mournful
odorful1143483odor_ful
potful1138083po_tful
poutful1236743poutful
rackful1645873rackful
roomful1244183roomful
sackful1645353sackful
scornful1343333scornful
sobful1136333so_bful
songful1145173songful
soulful1045293soulful
sportful1344513sportful
tankful1445163tankful
toilful1044813toilful
topful1136543to_pful
woeful1236363wo_eful
woful1158173wo__ful
workfolk1742343workfolk
workout1448393workout
workup1534323work_up
worthful1743463worthful

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.440406115.9
2DLD Change Limit134027806.61020276.4
3Display Results80800.0302666.7
 (SQL Overall)178691807.08025238.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.