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

466 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
format11302135(None) 
forgat104018581forgat
formal113215201formal
formant123416001formant
formate123115091formate
formats123113571formats
doormat1059072doormat
dormant102814372dormant
fermata12278142fermata
fermate122813002fermate
firman112211342firman
foeman11311232foeman
fora75937392for_a_
foram105124932for_am
forams115115912forams
foray115023972for_ay
forbad122710502forbad
foreman12312362foreman
foremast1348612foremast
forest94926742forest
forget106326392forget
forgot104318132forgot
forint9325022forint
form95836872form__
formals123312892formals
formants13269952formants
formates132814292formates
forme105225992form_e
formed125021172formed
formee113919942formee
former114221402former
formes114623712formes
formic13310452formic
formol112910332formol
forms105327052form_s
formyl14276442formyl
forrit91916622forrit
fort76456442for__t
frat75648542f_r_at
korat94934432kor_at
korma115913072korma_
kormas124511232kormas
normal83213532normal
reformat1357652reformat
airman82414223airman
aorist64827873aorist
aorta55922573aorta_
aortae65115473aortae
aortal65217513aortal
aortas65417783aortas
arhat8327093_arhat
armet76739453_armet
aroma71220143aroma_
aromas81018613aromas
barman103519703barman
boat66360313bo__at
bobcat12411253bobcat
bora66141633bor_a_
boral75831703bor_al
boras75938303bor_as
borate85026153bor_ate
borax145918723bor_ax
boreal84817213boreal
boreas85421733boreas
borsht11813503borsht
bort65960963bor__t
bowman13129853bowman
brat66055543_br_at
bromal10313653bromal
bromate11313553bromate
carat75048793car_at
carman103920743carman
cermet10321153cermet
coat67558353co__at
cocomat13413623cocomat
coempt12311033coempt
coma87134853co_ma_
comae97128423co_mae
comal95125133co_mal
comas95833003co_mas
comate104124843co_mate
combat12316753combat
comet95946073co_met
comma114514793comma_
commas124814573commas
commata1338483commata
commit124016703commit
compt116328223co_mpt
coral76033453cor_al
corban10314693corban
cordate10315223cordate
coria75828323coria_
corm85735373corm__
cormel103815603cormel
corms95626223corm_s
cornet84436733cornet
corral83616253corral
corsac10410173corsac
corset85636223corset
corvet114626933corvet
cowman13910373cowman
cowpat13312033cowpat
derat65044083der_at
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
doat56947673do__at
dogma96112463dogma_
dogmas105011243dogmas
dogmata1145143dogmata
dolma86214173dolma_
dolman95312403dolman
dolmas95213043dolmas
domal85619203do_mal
doorman1037063doorman
doormats1145413doormats
dorm76834633dorm__
dormer94415903dormer
dormie9312623dormie
dormin9312313dormin
dorms85723843dorm_s
dormy115817473dorm_y
dorsa64617283dorsa_
dorsad8408973dorsad
dorsal74613943dorsal
douma85817703douma_
doumas95314813doumas
drat56247833_dr_at
durmast1037623durmast
farad95720673far_ad
farfal123410183farfal
farm95934533farm__
farmed125117653farmed
farmer115017373farmer
farms106324953farm_s
fart76860563far__t
fat68178083f___at
feat76458223f__eat
feral85424653fer_al
ferbam1339003ferbam
feria85922713feria_
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
fermatas13246223fermatas
ferment12315573ferment
fermi103914163ferm_i
fermis114313503fermis
ferrate103014043ferrate
ferret93021173ferret
fiat76646643f__iat
fireman1249333fireman
firm96026453firm__
firmans12238523firmans
firmed125411883firmed
firmer114712443firmer
firmest1239273firmest
firmly1436663firmly
firms105217423firm_s
first86226123fir_st
flat77147823f__lat
float85928573f_loat
flora85317103flor_a_
florae94713883flor_ae
floral94313813flor_al
floras94715693flor_as
floret9321123flor_et
florist10314243florist
floruit1047293floruit
flyman14326423flyman
foal76630923fo__al
foam97127173fo__am
foamed126014403foamed
foamer114714313foamer
foams105017953foam_s
foamy135313203foam_y
focal104917673fo_cal
foemen11310523foemen
foetal9311883foetal
foist85730973fo_ist
folate93320393fo_late
folia83618933folia_
foliar93210973foliar
foliate10513533foliate
folkmot1675683folkmot
foment113718303foment
fomite113314073fo_mite
fondant11311143fondant
font77143753fo__nt
fontal9313143fontal
foot76248013fo__ot
footman1236403footman
for66952073for___
forage104617003forage
foramen12310533foramen
forays124813003forays
forb97131333for__b
forbade13259103forbade
forbare122310513forbare
forbear1237523forbear
forbid123312433forbid
forbs105720803for_bs
forby135317673for_by
forbye14427883forbye
force105324273for_ce
forced126316523forced
forcemeat1644253forcemeat
forcer114917343forcer
forces114422133forces
ford86835493for__d
forded115020393forded
fordid113512053fordid
fordo97218653for_do
fords95328183for_ds
fore78351473for__e
forearm1238693forearm
forebay1538133forebay
foreby1438633foreby
forecast1349763forecast
foredate12310913foredate
foredo10510823foredo
forego1038903forego
foregut1149163foregut
foremasts1445793foremasts
foremen12412923foremen
foremost1348583foremost
forepart1349703forepart
forepast1348043forepast
forepaw1595613forepaw
foreran10311793foreran
fores85847103for_es
foresaw1377133foresaw
forests104114953forests
forfeit1339203forfeit
forgave1435853forgave
forge95126943for_ge
forged115519323forged
forger104820773forger
forges105024263forges
forgets113813793forgets
forgo94418333for_go
forints10411833forints
fork115930943for__k
forked145217143forked
forker134717903forker
forks125324683for_ks
forky156119643for_ky
formable1539503formable
formably1846663formably
formalin1347313formalin
formalist141910643formalist
formality1746983formality
formally1638243formally
formation1439423formation
formative1747963formative
formatted1544883formatted
formatter1445463formatter
formers128217953formers
formful1545183formful
formica1436443formica
formicas1546003formicas
forming133615733forming
formols12299413formols
formula1246293formula
formulae1345983formulae
formulas1346303formulas
formulate1446993formulate
formyls15235703formyls
fornent10312933fornent
fornix1636033fornix
forsake1436533forsake
forte86131463for_te
fortes95327183fortes
forth116222673for_th
fortis95418613fortis
forts86034453for_ts
forty114824273for_ty
forum108318763for_um
forums114611843forums
forward1438293forward
forwent13310533forwent
forwhy1834423forwhy
fossa85812633fossa_
fossae95510373fossae
fossas94610703fossas
fossate10388603fossate
fought135112393fought
fount84727033fo_unt
fovea11310483fovea_
foveae1237563foveae
foveal1237703foveal
foveas1238623foveas
foveate1338363foveate
frae75330473f_r_ae
frag85126273f_r_ag
frame105821803f_rame
frap95925813f_r_ap
frats86829673f_r_ats
fray105428903f_r_ay
freak125115243f_reak
fret75845043f_r_et
friar85414273f_riar
frit77044473f_r_it
fritt86129413f_ritt
frogman1335873frogman
from96923923from__
fromage1336753fromage
front85029223f_ront
frost84727833f_rost
frowst125512073frowst
fruit85122223f_ruit
fulmar1137253fulmar
fumet105630223f_umet
furan84320013fur_an
furcate12310453furcate
furmety1534813furmety
furmity1535183furmity
german9611983german
goat56250833go__at
goral65125753gor_al
gorget87123863gorget
gorm75529393gorm__
gormand1157453gormand
gormed105013833gormed
gorms85619593gorm_s
gourmet1059203gourmet
grat55651283_gr_at
great66034243_great
groat65531973_groat
hazmat20312263hazmat
hereat93527413hereat
herma105318883herma_
hermae115314473hermae
hermai118912863hermai
hermit11519443hermit
hora76136563hor_a_
horah117922053hor_ah
horal86328683hor_al
horas86333103hor_as
hornet94926433hornet
horst85833513hor_st
informal1355643informal
informant1446473informant
joram145816983jor_am
jorams154810533jorams
jordan1468063jordan
jurat124829323jur_at
karat96837593kar_at
karma113415003karma_
karmas123013733karmas
kismat123011673kismat
kora86431553kor_a_
korai97018523kor_ai
koras95927113kor_as
korats105416063kor_ats
lariat6629043lariat
loquat1558283loquat
loral55927823lor_al
loran55925093lor_an
loreal63814313loreal
louma76213633louma_
loumas84812333loumas
lovat8321043lo_vat
marmot10318743marmot
mat58083943___mat
merman10513863merman
moat66352033mo__at
momma85111053momma_
mommas94110653mommas
mora66641273mor_a_
morae75831193mor_ae
moral75533433mor_al
moras76438773mor_as
moray105423793mor_ay
mordant10312403mordant
morgan9311373morgan
mort66758833mor__t
mortal84616853mortal
mortar83812043mortar
motmot10311073motmot
noma67529463no_ma_
nomad86016183no_mad
nomas74726413no_mas
nonfat9512183nonfat
nonman8412363nonman
nonmeat9312773nonmeat
noria55722183noria_
norias65518203norias
norm66429813norm__
normals92510903normals
normed95014543normed
norms76019313norm_s
nougat74712653nougat
oat39888263_o__at
omit65337373_o_mit
ora37250833_or_a_
orad56031693_or_ad
oral47638123_or_al
orate55133303_or_ate
orbit73622063_orbit
orca65522773_orca_
orcas75918623_orcas
oread64619603_oread
organ6915393_organ
orgeat7515033_orgeat
ormer75218373_ormer
ornate6315133_ornate
orra46120723_orra_
ort39465233_or__t
permit10321683permit
port66059633por__t
portal84218463portal
potman102813573potman
prat65952043_pr_at
preformat1646363preformat
prompt12313013prompt
rat37892743__r_at
reformate1446953reformate
reformats1445713reformats
rodman949713rodman
roman75424823ro_man
sforzato2041713sforzato
socman1039813socman
soma65635293so_ma_
soman75024903so_man
somas76030373so_mas
somata8312383so_mata
sora45746913sor_a_
soras55041013sor_as
sorbate9311733sorbate
sorbet83924083sorbet
sorest65028003sorest
sort46264813sor__t
sorta57125413sorta_
sprat76635973spr_at
tarmac10310333tarmac
threat95020463threat
throat94819753throat
toman75724053to_man
tomato8313453to_mato
tomcat101013453tomcat
topmast1138123topmast
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
torment9316173torment
torot56139943tor_ot
tort46967463tor__t
torta55925353torta_
tortas64918253tortas
treat56240353_treat
vomit102622573vo_mit
woman105818003wo_man
wombat1339863wombat
workman1635613workman
workmate1744673workmate
worm96129483worm__
wormed124314303wormed
wormer114514913wormer
wormil1138043wormil
worms105320763worm_s
wormy137514253worm_y
worrit92313313worrit
worset96726583worset
worst86330133wor_st
wort76654753wor__t

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127164665.72019705.6
3Display Results4664660.1403328.6
 (SQL Overall)1786914665.98329866.5
 
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.