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

160 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
fromage133675(None) 
fromages1437071fromages
brokage1436672brokage
bromate11313552bromate
flotage1136682flotage
flowage1435722flowage
footage1148842footage
forage104617002f_orage
formate123115092formate
frontage1296242frontage
frottage1245082frottage
homage121210602_homage
primage12169142primage
aroma71220143aroma__
aromas81018613aroma_s
baronage1147073baronage
borage93917013_borage
brewage1347183brewage
brocade1238533brocade
brockage1744743brockage
brokages1536253brokages
bromal10313653broma_l
bromals1139743bromals
bromated1339173bromated
bromates12413143bromates
brome94421973brom__e
bromide12269583bromide
bromine112915243bromine
bromize20238823bromize
buoyage1344293buoyage
chromate15312783chromate
comade114415323_comade
comae97128423_coma_e
comake144413423_comake
comate104124843_comate
cordage11310063cordage
corkage1438373corkage
corsage1039803corsage
cowage12310673_cowage
cremate113816183cremate
damage10410773_damage
dosage82810003_dosage
dotage82711613_dotage
drayage1234423drayage
ecotage1036883ecotage
female11310553f_emale
fermate122813003fermate
ferriage1245463ferriage
floatage1244403floatage
floorage1275093floorage
florae94713883flora_e
flotages1237163flotages
flowages1535733flowages
foggage1334113foggage
folate93320393f_olate
foliage1147533foliage
fomite113314073f_omite
footages1239053footages
foraged124812283f_oraged
forager114412563f_orager
forages114217283f_orages
forbade13259103forbade
forbare122310513forbare
forgave1435853forgave
forge95126943f_o_rge
formable1539503formable
formal113215203forma_l
formals123312893formals
formant123416003formant
format113021353forma_t
formates132814293formates
formats123113573formats
forme105225993form__e
formee113919943form_ee
forsake1436533forsake
frae75330473fr__a_e
frag85126273fr__ag_
frags96322173fr__ags
framable1537573framable
frame105821803fr__ame
fridge11379253fr_idge
frigate11311063frigate
fringe104013953fr_inge
froe75329993fro___e
frog85624363fro__g_
frogeye1443813frogeye
frogged13408493fro_gged
froggy1434493fro_ggy
frogman1335873frogma_n
frogs96220773fro__gs
from96923923from___
frontages13116183frontages
frontpage15102633frontpage
frore86218803fro__re
frottages1384993frottages
frounce1236153frounce
froward1436673froward
froze174515653fro__ze
fruitage1244343fruitage
grimace1255083grimace
homaged1497413_homaged
homager13107853_homager
homages131011583_homages
image81411293__image
lovage1037353_lovage
mage75739133___mage
moorage1038743moorage
nonage7313683_nonage
ohmage1295063_ohmage
peonage1048723peonage
plumage1245503plumage
pomace123111913_pomace
pomade113611333_pomade
portage103013643portage
potage92715903_potage
premade12311443premade
presage10312293presage
primages13159273primages
primate111516283primate
probate11414483probate
profane122111863profane
prolate9419793prolate
promine112819443promine
promise113415843promise
promote11313143promote
promulge1343043promulge
pronate9418873pronate
propane112716153propane
prophage1649433prophage
prorate9418733prorate
protege1059153protege
rage55742353_r__age
ramate83921683_ramate
rampage1237453_rampage
ravage1039303_ravage
reimage1037913reimage
remade94316983_remade
remake124016113_remake
remate84428683_remate
rivage1038843_rivage
romaine9512123_romaine
romaji1534893_romaji
roman75424823_roma_n
romance11311083_romance
romano84912943_romano
romans84620243_romans
rootage839053rootage
rotate63320343_rotate
rouge65423443_ro_uge
rummage1234583rummage
socage91012123_socage
stomate9313123stomate
storage8310473storage
stowage1136703stowage
towage1039833_towage
triage72812893tr_iage
trompe105611263trom_pe
vorlage1136403vorlage
voyage1335473_voyage
wordage1236503wordage

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 Limit1340271607.03019065.0
3Display Results1601600.0632539.7
 (SQL Overall)1786911607.49923828.6
 
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.