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

370 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
formats12311357(None) 
formals123312891formals
formants13269951formants
format113021351format_
formate123115091formate
formates132814291formates
doormats1145412doormats
fermata12278142fermata
fermatas13246222fermatas
fermate122813002fermate
firmans12238522firmans
forams115115912for_ams
forays124813002for_ays
foremast1348612foremast
foremasts1445792foremasts
forests104114952forests
forgat104018582forgat_
forgets113813792forgets
forints10411832forints
formal113215202forma_l
formant123416002formant
formers128217952formers
formes114623712form_es
formols12299412formols
forms105327052form__s
formyls15235702formyls
forts86034452for__ts
frats86829672f_r_ats
korats105416062kor_ats
kormas124511232korma_s
normals92510902normals
reformats1445712reformats
aorists74215833aorists
aortas65417783aorta_s
arhats9312973_arhats
armets84918353_armets
aromas81018613aroma_s
boats75635153bo__ats
bobcats1335993bobcats
borals86721913bor_als
boras75938303bor_a_s
borate85026153bor_ate
borates94823013bor_ates
boreas85421733borea_s
borshts1266543borshts
borts76735453bor__ts
brats75336013_br_ats
bromals1139743bromals
bromate11313553bromate
bromates12413143bromates
carats85929023car_ats
cermets1139713cermets
coats75635003co__ats
cocomats1449403cocomats
coempts1335683coempts
comas95833003co_ma_s
comate104124843co_mate
comates114123643co_mates
combats13311683combats
comets105823583co_mets
commas124814573comma_s
commata1338483commata
commits133812383commits
compts125216653co_mpts
corals85325143cor_als
corbans11313173corbans
cordate10315223cordate
cormels113813373cormels
cormous11312353cormous
corms95626223corm__s
cornets94820573cornets
corrals93713853corrals
corsacs1139013corsacs
corsets94819803corsets
corvets124715023corvets
cowpats1437713cowpats
derats74625063der_ats
dermas94116813derma_s
doats65224883do__ats
dogmas105011243dogma_s
dogmata1145143dogmata
dolmans10479683dolmans
dolmas95213043dolma_s
doormat1059073doormat_
dormant102814373dormant
dormers104313923dormers
dormins10311273dormins
dorms85723843dorm__s
dorsals84110843dorsals
doumas95314813douma_s
drats66628373_dr_ats
durmast1037623durmast
durmasts1144093durmasts
farads104713273far_ads
farfals13268503farfals
farmers124315263farmers
farms106324953farm__s
farts88336843far__ts
fats76252503f___ats
feats86432753f__eats
ferals94216643fer_als
ferbams1435743ferbams
ferias95020393feria_s
ferments13311473ferments
fermis114313503ferm_is
ferrate103014043ferrate
ferrates113013423ferrates
ferrets103111393ferrets
fiats85324483f__iats
firman112211343firma_n
firmers124711443firmers
firmest1239273firmest
firms105217423firm__s
firsts95110923fir_sts
flats86429743f__lats
floats96816253f_loats
florals104210063flor_als
floras94715693flor_a_s
florets1039853flor_ets
florists1138813florists
floruits1145153floruits
foals85721693fo__als
foamers123812103foamers
foams105017953fo__ams
foeman11311233foema_n
foists95413983fo_ists
folate93320393fo_late
folates103218453fo_lates
foliate10513533foliate
foliates11412753foliates
folkmots1783603folkmots
foments122912053foments
fomite113314073fo_mite
fomites123613203fo_mites
fondants1246203fondants
fonts86124753fo__nts
foots85528283fo__ots
fora75937393for_a__
forage104617003for_age
forages114217283forages
foram105124933for_a_m
foramen12310533foramen
foramens1337823foramens
foray115023973for_a_y
forbad122710503forba_d
forbade13259103forbade
forbare122310513forbare
forbears1337073forbears
forbids13268263forbids
forbs105720803for__bs
forcemeats1742813forcemeats
forceps14466983forceps
forcers124215713forcers
forces114422133for_ces
fordoes11311963fordoes
fords95328183for__ds
forearm1238703forearm
forearms1336603forearms
forebays1637263forebays
forecast1349763forecast
forecasts1445803forecasts
foredate12310913foredate
foredates13310053foredates
foreguts1245563foreguts
foreman12312363forema_n
foremost1348583foremost
foreparts1445223foreparts
forepast1348043forepast
forepaws1695753forepaws
fores85847103for__es
forest94926743forest_
forfeits1445803forfeits
forgave1435853forgave
forgers115218183forgers
forges105024263for_ges
forget106326393forget_
forgoes11311353forgoes
forgot104318133forgot_
forint9325023forint_
forkers144615783forkers
forks125324683for__ks
form95836873form___
formable1539503formable
formably1846663formably
formalin1347313formalin
formalins1447213formalins
formalise14239783formalise
formalism16218183formalism
formalist141910643formalist
formalists15217623formalists
formality1746993formality
formally1638243formally
formation1439423formation
formations1538203formations
formative1747963formative
formatives1846213formatives
formatted1544883formatted
formatter1445463formatter
formatters1544573formatters
forme105225993form__e
formed125021173form_ed
formee113919943form_ee
former114221403form_er
formful1545183formful
formic13310453form_ic
formica1436443formica
formicas1546003formicas
forming133615733forming
formless13248083formless
formol112910333form_ol
formula1246293formula
formulas1346303formulas
formulate1446993formulate
formulates1546543formulates
formyl14276443form_yl
forrit91916623forrit_
forsake1436533forsake
forsakes1536893forsakes
fort76456443for__t_
forte86131463for__te
fortes95327183for_tes
forth116222673for__th
forties104323863forties
fortis95418613for_tis
forty114824273for__ty
forums114611843for_ums
forward1438293forward
forwards1537043forwards
fossas94610703fossa_s
fossate10388603fossate
founts94313383fo_unts
foveas1238623fovea_s
foveate1338363foveate
frags96322173f_r_ags
frames115119863f_rames
fraps105620553f_r_aps
frass85321123f_r_ass
frat75648543f_r_at_
frays116920103f_r_ays
freaks134713063f_reaks
frets85523403f_r_ets
friars93812093f_riars
frits86129103f_r_its
fritts94613193f_ritts
fromage1336753fromage
fromages1437073fromages
fronts94415793f_ronts
frosts94214623f_rosts
frowsts13426103frowsts
fruits94512493f_ruits
fulmars1246423fulmars
fumets114311813f_umets
furans94515953fur_ans
furcate12310453furcate
furcates1339883furcates
furmety1534813furmety
furmity1535183furmity
germans1079473germans
goats65527303go__ats
gorals76917653gor_als
gorgets94711783gorgets
gormand1157453gormand
gormands1266563gormands
gorms85619593gorm__s
gourmets1144153gourmets
greats76318393_greats
groats74816653_groats
hazmats2136603hazmats
hermits12312143hermits
horahs126313873hor_ahs
horas86333103hor_a_s
hornets104113553hornets
horsts95817513hor_sts
informants1544633informants
jorams154810533jor_ams
jordans1566833jordans
jurats134213203jur_ats
karats106420493kar_ats
karmas123013733karma_s
kismats13257843kismats
koras95927113kor_a_s
korat94934433kor_at_
korma115913073korma__
lariats7615053lariats
loggats9286453loggats
loquats1645273loquats
lorans65117603lor_ans
loumas84812333louma_s
lovats939073lo_vats
marmots11311513marmots
mats65460293___mats
moats75827643mo__ats
mommas94110653momma_s
morals85324633mor_als
moras76438783mor_a_s
morass84614503mor_ass
morays114613883mor_ays
mordants1137143mordants
morgans10310123morgans
mortals93914003mortals
mortars93411523mortars
morts75533563mor__ts
motmots1166133motmots
nomads94711603no_mads
nomas74726413no_ma_s
norias65518203noria_s
normal83213533norma_l
norms76019313norm__s
nougats8427413nougats
oats46554213_o__ats
omits75018263_o_mits
orals55826483_or_als
orate55133303_or_ate
orates64328613_or_ates
orbits84211443_orbits
orcas75918623_orca_s
oreads73915773_oreads
organs7912913_organs
orgeats838353_orgeats
ormers84316143_ormers
ornate6315143_ornate
orts46538333_or__ts
permits11314003permits
portals94015563portals
ports75934593por__ts
prats76333393_pr_ats
preformats1744413preformats
prompts1337473prompts
rats46260373__r_ats
reformat1357653reformat_
reformate1446953reformate
reformates1546263reformates
romans84620243ro_mans
sforzato2041713sforzato
sforzatos2141623sforzatos
somans84619303so_mans
somas76030373so_ma_s
somata8312383so_mata
soras55041013sor_a_s
sorbate9311733sorbate
sorbates10311103sorbates
sorbets93012513sorbets
sorts54536663sor__ts
sprats85819933spr_ats
tarmacs1138323tarmacs
threats104311673threats
throats104612193throats
tomans85419133to_mans
tomato8313453to_mato
tomcats11127773tomcats
topmast1138123topmast
topmasts1244973topmasts
torahs95115643tor_ahs
toras55540373tor_a_s
torments10310453torments
tortas64918253torta_s
torts56138123tor__ts
treats64821693_treats
vomits112610923vo_mits
womans114613653wo_mans
wombats1435893wombats
workmate1744673workmate
workmates1845003workmates
wormers124012573wormers
wormils1236733wormils
worms105320763worm__s
worrits10258683worrits
worsets105512843worsets
worsts96014333wor_sts
worts88631183wor__ts

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.393454684.5
2DLD Change Limit1340273706.46620728.0
3Display Results3703700.1262936.5
 (SQL Overall)1786913706.98525582.1
 
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.