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

139 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
fromages143707(None) 
fromage1336751fromage_
brokages1536252brokages
bromates12413142bromates
flotages1237162flotages
flowages1535732flowages
footages1239052footages
forages114217282f_orages
formates132814292formates
frontages13116182frontages
frottages1384992frottages
homages131011582_homages
primages13159272primages
aromas81018613aroma__s
baronages1247153baronages
borages103917163_borages
brewages1436383brewages
brocades1358713brocades
brockages1844783brockages
brokage1436673brokage_
bromals1139743broma_ls
bromate11313553bromate_
bromated1339173bromated
bromes104719763brom__es
bromides13219363bromides
bromines122514253bromines
bromizes21258333bromizes
buoyages1443803buoyages
chromates16313113chromates
comakes154413643_comakes
comates114123643_comates
cordages12310113cordages
corkages1539103corkages
corsages11310363corsages
cowages13310943_cowages
cremates124216003cremates
damages11511283_damages
dosages92310803_dosages
dotages92311793_dotages
drayages1344513drayages
ecotages1136973ecotages
females12310663f_emales
ferriages1345663ferriages
floatages1344233floatages
floorages1364983floorages
flotage1136683flotage_
flowage1435723flowage_
foggages1434213foggages
folates103218453f_olates
foliages1247623foliages
fomites123613203f_omites
footage1148843footage_
forage104617003f_orage_
foraged124812283f_oraged
forager114412563f_orager
foragers12349633f_oragers
forges105024263f_o_rges
formals123312893forma_ls
formants13269953formants
formate123115093formate_
formats123113573forma_ts
formes114623713form__es
forsakes1536893forsakes
fracases1336993fracases
frags96322173fr__ag_s
frames115119863fr__ames
fridges12369483fr_idges
frigates12310933frigates
friges104116483fr__iges
fringes113514103fr_inges
froes86126693fro___es
frogeyes1543743frogeyes
frogged13408493fro_gged
frogs96220773fro__g_s
frontage1296243frontage_
frontes104214163fro_ntes
frontpages1692643frontpages
frottage1245083frottage_
frounces1336183frounces
fruitages1344483fruitages
grimaces1355383grimaces
homage121210603_homage_
homaged1497413_homaged
homager13107853_homager
homagers1486823_homagers
images91411463__images
lovages1138033_lovages
mages85036023___mages
moorages1139053moorages
nonages8313843_nonages
ohmages13115093_ohmages
peonages1138473peonages
plumages1335653plumages
pomaces132712123_pomaces
pomades123711733_pomades
portages112613223portages
potages102416423_potages
presages11312203presages
primage12169143primage_
primates121515933primates
probates12414283probates
profanes132311573profanes
promines123018803promines
promises122916763promises
promotes12314123promotes
promulges1443383promulges
pronates10418373pronates
propanes122415823propanes
prophages1749763prophages
prorates10418073prorates
protases102115033protases
proteges1149923proteges
rages64539443_r__ages
rampages1336673_rampages
ravages1139403_ravages
reimages1138373reimages
remakes134116173_remakes
remates93827113_remates
remiges103015473_remiges
rivages1138873_rivages
romaines10512523_romaines
romajis1635913_romajis
romances12310793_romances
romanos94311483_romanos
romans84620243_roma_ns
rootages939103rootages
rotates72819773_rotates
rouges76022383_ro_uges
rummages1344933rummages
socages101012053_socages
stomates10313343stomates
storages9311103storages
stowages1236473stowages
towages1139233_towages
triages82613793tr_iages
trompes114111623trom_pes
vorlages1236033vorlages
voyages1435703_voyages
wordages1337053wordages

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621396.47022590.7
3Display Results1391390.0602316.7
 (SQL Overall)1786911396.95325699.8
 
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.