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

345 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
formate12311509(None) 
fermate122813001fermate
format113021351format_
formates132814291formates
formats123113571formats
borate85026152bor_ate
bromate11313552bromate
comate104124842co_mate
cordate10315222cordate
fermata12278142fermata
ferrate103014042ferrate
folate93320392fo_late
foliate10513532foliate
fomite113314072fo_mite
forage104617002for_age
forbade13259102forbade
forbare122310512forbare
foredate12310912foredate
forgat104018582forgat_
forgave1435852forgave
formable1539502formable
formal113215202forma_l
formals123312892formals
formant123416002formant
formants13269952formants
formative1747962formative
formatted1544882formatted
formatter1445462formatter
forme105225992form__e
formee113919942form_ee
formulate1446992formulate
forsake1436532forsake
forte86131462for__te
fossate10388602fossate
foveate1338362foveate
fromage1336752fromage
furcate12310452furcate
orate55133302_or_ate
ornate6315142_ornate
reformate1446952reformate
sorbate9311732sorbate
workmate1744672workmate
aerate64830553aer_ate
agemate101210583agemate
airdate8311323airdate
animate91617213animate
aortae65115473aorta_e
aurate64426473aur_ate
aureate72515283aureate
barbate11314543barbate
bedmate1239433bedmate
berate84729023ber_ate
biforate1346903bifor_ate
borage93917013bor_age
borane84620213bor_ane
borated104116363bor_ated
borates94823013bor_ates
bornite9311183bornite
bromated1339173bromated
bromates12413143bromates
bursate94111203bursate
carate84734003car_ate
cerate84829463cer_ate
chordate1448033chordate
chromate15312783chromate
cirrate92413493cirrate
climate11312833climate
cocreate122611813cocreate
cognate10312203cognate
coinmate1239063coinmate
collate92919683collate
comade114415323co_made
comae97128423co_ma_e
comake144413423co_make
comates114123643co_mates
commata1338483commata
commute134310443commute
comrade12139213comrade
comte96125473co_m_te
connate9315753connate
copemate1439993copemate
cordage11310063cordage
cordite10315263cordite
corelate10516013corelate
corkage1438373corkage
cornute939643cornute
coronate103018213coronate
corotate102813933corotate
corrade101111043corrade
corsage1039803corsage
costate94019273costate
crate76537403_cr_ate
create85126383_create
cremate113816183cremate
curate85226243cur_ate
curtate9312643curtate
derate74531233der_ate
dogmata1145143dogmata
donate73619503do_nate
doormat1059073doormat_
doormats1145413doormats
dormant102814373dormant
dormice1237133dormice
dormie9312623dorm_ie
ergate7315143_ergate
falcate12311623falcate
farmable1538203farmable
fate75444283f___ate
fellate10313433fellate
female11310553f_emale
feriae95618603feria_e
fermatas13246223fermatas
ferrates113013423ferrates
ferrite103312753ferrite
filiate10414233filiate
firman112211343firma_n
firmans12238523firmans
firmware1643963firmware
fissate103010033fissate
fixate1638733f_ixate
flatmate1346393flatmate
florae94713883flor_a_e
floreated1346573floreated
floriated1347023floriated
foamable1537043foamable
foeman11311233foema_n
foggage1334113foggage
folates103218453fo_lates
foliage1147533foliage
foliated1249913foliated
foliates11412753foliates
folkmote1763343folkmote
fomites123613203fo_mites
footage1148843footage
fora75937393for_a__
foraged124812283for_aged
forager114412563for_ager
forages114217283for_ages
foram105124933for_a_m
foramen12310533foramen
forams115115913for_ams
foray115023973for_a_y
forayed14368593for_ayed
forayer13368953for_ayer
forays124813003for_ays
forbad122710503forba_d
forbode13257963forbode
forbore12249673forbore
forbye14427883for_bye
force105324273for__ce
fordable1439593fordable
fordone1149383fordone
fore78351473for___e
forearm1238703forearm
forebye1536353forebye
foredated1447683foredated
foredates13310053foredates
foreface1647113foreface
foreman12312363forema_n
foremast1348613foremast
foremasts1445793foremasts
forename1347853forename
foresee10414333foresee
forest94926743forest_
forested12312463forested
forester11313673forester
forests104114953forests
foretaste1295863foretaste
forficate1745123forficate
forgather1643663forgather
forge95126943for__ge
forget106326393forget_
forgets113813793forgets
forgive1436193forgive
forgone1139343forgone
forgot104318133forgot_
forint9325023forint_
forints10411833forints
form95836873form___
formably1846663formably
formalin1347313formalin
formalise14239783formalise
formality1746993formality
formalize232710033formalize
formally1638243formally
formamide1744403formamide
formation1439423formation
formatives1846213formatives
formatters1544573formatters
formed125021173form_ed
former114221403form_er
formers128217953formers
formes114623713form_es
formful1545183formful
formic13310453form_ic
formica1436443formica
forming133615733forming
formol112910333form_ol
formols12299413formols
forms105327053form__s
formula1246293formula
formulae1345983formulae
formulated1645563formulated
formulates1546543formulates
formyl14276443form_yl
formyls15235703formyls
fornicate1446083fornicate
forrader1236153forrader
forrit91916623forrit_
forsaken1543353forsaken
forsaker1545103forsaker
forsakes1536893forsakes
fort76456443for__t_
fortes95327183for__tes
forth116222673for__th
forts86034453for__ts
fortunate1245453fortunate
fortune1068303fortune
forty114824273for__ty
forward1438293forward
fossae95510373fossa_e
fouette1038213fouette
foveae1237563fovea_e
foveated1536293foveated
frae75330473f_r_a_e
frame105821803f_r_ame
frat75648543f_r_at_
frater94520593f_r_ater
frats86829673f_r_ats
frigate11311063frigate
fromages1437073fromages
furane94015493fur_ane
furcated1437593furcated
furcates1339883furcates
furmety1534813furmety
furmity1535183furmity
furnace1235943furnace
gemmate12418383gemmate
germane1049663germane
gormand1157453gormand
grate64932883_gr_ate
gyrate104912523gyr_ate
hamate113319833_hamate
hermae115314473herma_e
hogmane1336343hogmane
homage121210603ho_mage
hormone12410503hormone
horste94817413hor_ste
humate113214443_humate
imamate1138103imamate
inmate82917363_inmate
iodate7313503io_date
irate55627983_ir_ate
karate105320923kar_ate
korat94934433kor_at_
korats105416063kor_ats
korma115913073korma__
kormas124511233korma_s
lobate82915243lo_bate
locate83919843lo_cate
loricate10310663loricate
lyrate94112103lyr_ate
mammate104411273mammate
marmite112413993marmite
mate65154223___mate
mismate111415353mismate
morae75831193mor_a_e
morale85220553mor_ale
muriate9313363muriate
narrate7313493narrate
nervate1039533nervate
norite63221133nor_ite
normal83213533norma_l
normals92510903normals
normande1145943normande
normative1448893normative
notate63217863no_tate
oblate82214743_oblate
ocreate93711743ocreate
ohmage1295063_ohmage
oleate6318883_oleate
opiate8513463_opiate
orated74221503_or_ated
orates64328613_or_ates
outate62923403_outate
ovate84214393_o_vate
palmate113215233palmate
permeate12311613permeate
permute1138793permute
phorate12413363phor_ate
pirate82322883pir_ate
plumate1149803plumate
pomace123111913po_mace
pomade113611333po_made
portage103013643portage
prate75135983_pr_ate
primate111516283primate
probate11414483probate
prolate9419793prolate
promote11313143promote
pronate9418873pronate
prorate9418733prorate
ramate83921693_ramate
rate45458763__r_ate
reformat1357653reformat_
reformates1546263reformates
reformats1445713reformats
remate84428683_remate
roommate1244863roommate
roseate7613453roseate
rotate63320343ro_tate
seriate73722473seriate
serrate73017543serrate
sforzato2041713sforzato
sigmate10710143sigmate
solate64526073so_late
solvate102710213solvate
somata8312383so_mata
somite84519373so_mite
sorbates10311103sorbates
sororate8411173sororate
soulmate1047193soulmate
stomate9313123stomate
striate74218953striate
summate113611663summate
termite9313893termite
ternate7415483ternate
toccate1138773toccate
togate74515683to_gate
toluate7159343toluate
tomato8313453to_mato
torquate1745003torquate
torsade837593torsade
torte55431703tor__te
unornate848013unornate
uprate83916543upr_ate
urate55432163_ur_ate
variate101316433variate
virgate1138733virgate
volvate13317993volvate
vorlage1136403vorlage
wordage1236503wordage
workmates1845003workmates
yokemate1744313yokemate
zonate154114923zo_nate

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.420425454.8
2DLD Change Limit1340273456.83019623.3
3Display Results3453450.1262738.1
 (SQL Overall)1786913457.37624226.0
 
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.