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

99 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
formful154518(None) 
forkful1744771forkful
armful1167162_armful
doomful1343662doomful
forceful1644602forceful
forkfuls1843552forkfuls
forksful1842492forksful
formal113215212form_al
formol112910332form_ol
formula1246292form_ula
formyl14276442form_yl
harmful1535762harmful
roomful1244182roomful
aimful1166703_aimful
armfuls1275013_armfuls
armsful1284093_armsful
artful968273_artful
boatful1236283boatful
bookful1644773bookful
bowlful1544613bowlful
boxful18145273bo_xful
brimful1443883brimful
careful1249113careful
carful11610973car_ful
cormel103815603corm_el
cormous11312353cormous
dareful1157053dareful
direful1156613direful
doleful1146333doleful
earful958963ear_ful
effortful1451413effortful
factful1536373factful
farfal123410193far_fal
farfel124310433far_fel
fateful1397513fateful
fearful1345593fearful
fermium1446353fermium
fistful1365903fistful
fitful1256333f_itful
forefeel14105513forefeel
forefelt14117363forefelt
foregut1149163foregut
forerun1037653forerun
forgetful1642863forgetful
form95836873form___
formable1539503formable
formably1846663formably
formally1638243formally
formals123312893formals
formant123416003formant
format113021363form_at
formate123115093formate
formats123113573formats
forme105225993form__e
formed125021173form_ed
formee113919943form_ee
former114221403form_er
formerly1645003formerly
formers128217953formers
formes114623713form_es
formic13310453form_ic
formica1436443formica
forming133615733forming
formols12299413formols
forms105327053form__s
formulae1345983form_ulae
formulas1346303form_ulas
formyls15235703formyls
forum108318763for__um
foul77027583fo___ul
fretful1346143fretful
furfur1235553fur_fur
gloomful1441793gloomful
hopeful1545913hopeful
hurtful1344853hurtful
ireful948713_ireful
jarful1646683jar_ful
jarsful1744603jarsful
joyful1943843jo_yful
moanful12105003moanful
mournful1342503mournful
normal83213543norm_al
odorful1143483odor_ful
ormolu845833_ormolu
palmful1445053palmful
potful1138083po_tful
poutful1236743poutful
roomfuls1342833roomfuls
scornful1343333scornful
sobful1136333so_bful
songful1145173songful
soulful1045293soulful
sportful1344513sportful
toilful1044813toilful
topful1136543to_pful
woeful1236363wo_eful
woful1158173wo__ful
wormil1138043worm_il
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.406440125.6
2DLD Change Limit134027997.15618729.3
3Display Results99990.0462152.2
 (SQL Overall)178691997.60823487.3
 
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.