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

284 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
formates13281429(None) 
formate123115091formate_
formats123113571format_s
borates94823022bor_ates
bromates12413152bromates
comates114123642co_mates
fermatas13246222fermatas
fermate122813002fermate_
ferrates113013422ferrates
folates103218452fo_lates
foliates11412752foliates
fomites123613202fo_mites
forages114217282for_ages
foredates13310062foredates
formals123312892forma_ls
formants13269952formants
format113021362format__
formatives1846212formatives
formatted1544882formatted
formatter1445462formatter
formatters1544572formatters
formes114623712form__es
formulates1546542formulates
forsakes1536892forsakes
fortes95327182for__tes
fromages1437072fromages
furcates1339882furcates
orates64328612_or_ates
reformates1546262reformates
sorbates10311102sorbates
workmates1845002workmates
aerates74627503aer_ates
agemates111110033agemates
airdates939733airdates
animates101316423animates
bedmates1349193bedmates
berates94126883ber_ates
boraces113716853bor_aces
borages103917163bor_ages
boranes93720403bor_anes
borate85026153bor_ate_
borated104116363bor_ated
boraxes163511633bor_axes
boreases10310263boreases
bornites10310993bornites
bromate11313553bromate_
bromated1339173bromated
carates95630613car_ates
cerates95428253cer_ates
chordates1547683chordates
chromates16313113chromates
climates12311973climates
cocreates132611893cocreates
cognates11311583cognates
coinmates1348343coinmates
collates103019143collates
comakes154413643co_makes
comate104124843co_mate_
commutes143011893commutes
comrades13149773comrades
comtes106222813co_m_tes
copemates1549483copemates
cordages12310113cordages
cordate10315223cordate_
cordites11314633cordites
corelates11314873corelates
corkages1539103corkages
coronates1110816923coronates
corotates112714283corotates
corrades111211263corrades
corsages11310363corsages
crates85736063_cr_ates
creates95225213_creates
cremates124216013cremates
curates95323833cur_ates
derates84028893der_ates
dolmades1245463dolmades
donates83217223do_nates
doormats1145413doormat_s
ergates8314493_ergates
fates85139233f___ates
fellates11312753fellates
females12310663f_emales
fermata12278143fermat_a
ferrate103014043ferrate_
ferrites112312833ferrites
filiates11412663filiates
firmans12238523firma_ns
firmwares1743853firmwares
fixates1737393f_ixates
flatmates1446193flatmates
floreated1346573floreated
floriated1347023floriated
foggages1434213foggages
folate93320393fo_late_
foliages1247623foliages
foliate10513533foliate_
foliated1249913foliated
folkmotes1883283folkmotes
fomite113314073fo_mite_
footages1239053footages
forage104617003for_age_
foraged124812283for_aged
forager114412563for_ager
foragers12349633for_agers
foramen12310533for_amen
foramens1337823foramens
forams115115913for_a_ms
forayed14368593for_ayed
forayer13368953for_ayer
forayers14277273for_ayers
forays124813003for_a_ys
forbade13259103forbade_
forbare122310513forbare_
forbodes14217103forbodes
forces114422133for__ces
forcipes1535943forcipes
fordoes11311963for_does
forearms1336603forearms
foredate12310913foredate_
foredated1447683foredated
foredoes12310803foredoes
forefaces1747133forefaces
foregoes1239523foregoes
foremasts1445793foremasts
forenames1447543forenames
fores85847103for___es
foresees11311643foresees
forested12312463forested
forester11313673forester
foresters12312543foresters
forests104114953forest_s
foretastes1375593foretastes
forgat104018583forgat__
forgather1643663forgather
forgathers1743553forgathers
forgave1435853forgave_
forges105024263for__ges
forgets113813793forget_s
forgives1535753forgives
forgoes11311353for_goes
forints10411833forint_s
formable1539503formable
formably1846663formably
formal113215213forma__l
formalin1347313formalin
formalins1447213formalins
formalise14239783formalise
formalises15258993formalises
formalism16218183formalism
formalist141910643formalist
formalities16137823formalities
formalizes242710073formalizes
formally1638243formally
formalness1544833formalness
formamides1843873formamides
formant123416003forma_nt
formation1439423formation
formations1538203formations
formative1747963formative
forme105225993form__e_
formed125021173form__ed
formee113919943form__ee
former114221403form__er
formers128217953form_ers
formicas1546003formicas
formless13248083formless
formols12299413form_ols
forms105327053form___s
formulas1346303formulas
formulate1446993formulate_
formulated1645563formulated
formyls15235703form_yls
fornicates1545853fornicates
fornices1369103fornices
forrader1236153forrader
forsake1436533forsake_
forsaken1543353forsaken
forsaker1545103forsaker
forsakers1644653forsakers
forte86131463for__te_
forties104323863for_ties
fortis95418613for__tis
forts86034453for__t_s
fortunates1345263fortunates
fortunes1158283fortunes
forwards1537043forwards
fossate10388603fossate_
fouettes1137883fouettes
foveate1338363foveate_
foveated1536293foveated
frames115119863f_r_ames
frater94520593f_r_ater
fraters103517213f_r_aters
frats86829673f_r_at_s
frigates12310933frigates
frites94922483f_r_ites
fromage1336753fromage_
frontes104214163f_rontes
furanes103214863fur_anes
furcate12310453furcate_
furcated1437593furcated
furmeties1446583furmeties
furmities1447543furmities
furnaces1336053furnaces
gemmates13307673gemmates
gormands1266563gormands
grates75429893_gr_ates
gyrates113610263gyr_ates
hamates122917683_hamates
hogmanes1446783hogmanes
homages131011593ho_mages
hormones13311173hormones
horstes104516113hor_stes
humates122813193_humates
imamates1237663imamates
inmates92715783_inmates
iodates8312903io_dates
karates115617473kar_ates
korats105416063kor_at_s
kormas124511253korma__s
locates93218813lo_cates
loricates11310133loricates
marmites122212793marmites
mates75251363___mates
mismates121114563mismates
morales93619403mor_ales
muriates10312093muriates
narrates8312763narrates
norites74018803nor_ites
normals92510903norma_ls
notates72817483no_tates
oblates91913243_oblates
ohmages13115093_ohmages
oleates7417833_oleates
opiates9312143_opiates
orate55133303_or_ate_
orated74221503_or_ated
ornate6315143_ornate_
permeates13311773permeates
permutes1238713permutes
phorates13413043phor_ates
pirates93020333pir_ates
pomaces132712123po_maces
pomades123711733po_mades
portages112613223portages
prates84633163_pr_ates
primates121515933primates
probates12414283probates
promotes12314123promotes
pronates10418373pronates
prorates10418073prorates
rates55352013__r_ates
reformate1446953reformate_
reformats1445713reformat_s
remates93827123_remates
roommates1344843roommates
rotates72819773ro_tates
seriates82620683seriates
serrates82617023serrates
sforzatos2141633sforzatos
solates73523853so_lates
solvates11249673solvates
somites94219123so_mites
sorbate9311733sorbate_
sorites73825243sor_ites
sororates9410473sororates
soulmates1147073soulmates
stomates10313343stomates
striates83417093striates
summates122610493summates
termites10313693termites
toluates8138903toluates
tomatoes1038613to_matoes
torsades937213torsades
tortes64826053tor__tes
uprates93814863upr_ates
urates65027763_ur_ates
variates111214993variates
virgates1237923virgates
vorlages1236033vorlages
wordages1337053wordages
workmate1744673workmate_
yokemates1844193yokemates

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622846.64022012.3
3Display Results2842840.1102581.8
 (SQL Overall)1786912847.17324911.6
 
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.