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

357 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
formals12331289(None) 
formal113215201formal_
formats123113571formats
formols12299411formols
formyls15235701formyls
normals92510901normals
borals86721912bor_als
bromals1139742bromals
corals85325142cor_als
cormels113813372cormels
corrals93713852corrals
dorsals84110852dorsals
farfals13268502farfals
ferals94216642fer_als
firmans12238522firmans
florals104210062flor_als
foals85721692fo__als
forams115115912for_ams
forays124813002for_ays
formable1539502formable
formably1846662formably
formalin1347312formalin
formalins1447212formalins
formalise14239782formalise
formalism16218182formalism
formalist141910642formalist
formally1638242formally
formant123416002formant
formants13269952formants
format113021352forma_t
formate123115092formate
formates132814292formates
formers128217952formers
formes114623712form_es
formol112910332formol_
forms105327052form__s
formula1246292formula
formulas1346302formulas
formyl14276442formyl_
gorals76917652gor_als
kormas124511232korma_s
morals85324642mor_als
mortals93914012mortals
normal83213532normal_
orals55826482_or_als
portals94015562portals
wormils1236732wormils
abnormals1342773abnormals
aerials74017553aerials
airmails1045273airmails
animals94111703animals
aortal65217513aortal_
aortas65417783aorta_s
argals75517713_argals
aromas81018613aroma_s
boral75831703bor_al_
boras75938303bor_a_s
bordels103911973bordels
boreal84817213boreal_
boreas85421733borea_s
borstals1037473borstals
bromal10313653bromal_
burials93612083burials
carpals113414633carpals
ceramals1246513ceramals
cereals9313173cereals
chorals124614113chor_als
coals76129603co__als
coevals1237883coevals
comal95125133co_mal_
comas95833003co_ma_s
commas124814573comma_s
copals105018943co_pals
coral76033453cor_al_
corbans11313173corbans
corbels113813593corbels
cordials1139633cordials
cormel103815603cormel_
cormous11312353cormous
corms95626223corm__s
cornels94716663cornels
cornmeals1344583cornmeals
coronals103312913coronals
corral83616253corral_
corsacs1139013corsacs
craals84113303_craals
curtals93111623curtals
dermal93614343dermal_
dermas94116813derma_s
dismals102010243dismals
dogmas105011243dogma_s
dolmans10479683dolmans
dolmas95213043dolma_s
domal85619203do_mal_
doormats1145413doormats
dormant102814373dormant
dormers104313923dormers
dormins10311273dormins
dorms85723843dorm__s
dorsal74613943dorsal_
dorsels84412583dorsels
dossals8379303dossals
doumas95314813douma_s
facials123310743facials
fallals103310193fallals
farads104713273far_ads
fardels11389893fardels
farfal123410183farfal_
farfels13348213farfels
farls85731113far__ls
farmable1538203farmable
farmers124315263farmers
farms106324953farm__s
faucals12326563faucals
fecials123510333fecials
female11310553f_emale
females12310663f_emales
feral85424653fer_al_
ferbams1435743ferbams
ferial94621253ferial_
ferias95020393feria_s
fermata12278143fermata
fermatas13246223fermatas
fermate122813003fermate
fermis114313503ferm_is
ferrels10248623ferrels
ferulas103110753ferulas
fetials103711743fetials
finals94316163f_inals
finials103210153finials
firman112211343firma_n
firmers124711443firmers
firmly1436663firm_ly
firms105217423firm__s
fiscals1238003fiscals
floral94313813flor_al_
floras94715693flor_a_s
foal76630923fo__al_
foamable1537043foamable
foamers123812103foamers
foamily1546543foamily
foams105017953fo__ams
focal104917673fo_cal_
foeman11311233foema_n
foetal9311883foetal_
foils85025813fo__ils
fontal9313143fontal_
fools86824203fo__ols
fora75937393for_a__
forage104617003for_age
forages114217283forages
foram105124933for_a_m
foramen12310533foramen
foramens1337823foramens
foray115023973for_a_y
forbad122710503forba_d
forbade13259103forbade
forbare122310513forbare
forbears1337073forbears
forbidals1543493forbidals
forbids13268263forbids
forbs105720803for__bs
forceps14466983forceps
forcers124215713forcers
forces114422133for_ces
fordable1439593fordable
fordoes11311963fordoes
fords95328183for__ds
forearm1238703forearm
forearms1336603forearms
forebays1637263forebays
foreman12312363forema_n
foremast1348613foremast
foremasts1445793foremasts
foremilk1744373foremilk
foremilks1842783foremilks
forepaws1695753forepaws
fores85847103for__es
foresails1247153foresails
forests104114953forests
forgat104018583forga_t
forgave1435853forgave
forgers115218183forgers
forges105024263for_ges
forgets113813793forgets
forgoes11311353forgoes
forints10411833forints
forkball1744823forkball
forkballs1844253forkballs
forkers144615783forkers
forkfuls1843553forkfuls
forks125324683for__ks
form95836873form___
formalised16266663formalised
formalises15258993formalises
formalisms17227243formalisms
formalists15217623formalists
formality1746993formality
formalize232710033formalize
formalizes242710073formalizes
formalness1544833formalness
forme105225993form__e
formed125021173form_ed
formee113919943form_ee
former114221403form_er
formerly1645003formerly
formful1545183formful
formic13310453form_ic
formica1436443formica
formicas1546003formicas
forming133615733forming
formless13248083formless
formulae1345983formulae
formulism16214423formulism
formulist14205913formulist
forsake1436533forsake
forsakes1536893forsakes
fortes95327183for_tes
forties104323863forties
fortis95418613for_tis
forts86034453for__ts
forums114611843for_ums
forward1438293forward
forwards1537043forwards
fossas94610703fossa_s
fossils10379013fossils
fouls87221433fo__uls
foveal1237703foveal_
foveas1238623fovea_s
fowls115518893fo__wls
foxtails1844583foxtails
frags96322173f_r_ags
frails93716473f_rails
frames115119863f_rames
fraps105620553f_r_aps
frass85321123f_r_ass
frats86829673f_r_ats
frays116920103f_r_ays
freaks134713063f_reaks
friars93812093f_riars
frills94414223f_rills
fromage1336753fromage
fromages1437073fromages
frontals1146273frontals
fulmars1246423fulmars
fungals11276783fungals
furans94515953fur_ans
furls85322053fur__ls
germans1079473germans
gimmals12225823gimmals
goals65521293go__als
goorals838713goorals
goral65125753gor_al_
gormand1157453gormand
gormands1266563gormands
gorms85619593gorm__s
graals74112913_graals
hamals114816833_hamals
hammals14409233hammals
hartals10313023hartals
herbals122710613herbals
horahs126313873hor_ahs
horal86328683hor_al_
horas86333103hor_a_s
informal1355643informal_
jorams154810533jor_ams
jordans1566833jordans
jouals1338933jo_uals
journals1574353journals
karmas123013743karma_s
koras95927113kor_a_s
korats105416063kor_ats
korma115913073korma__
kraals10378433_kraals
locals83714503lo_cals
loral55927823lor_al_
lorans65117603lor_ans
loreal63814313loreal_
loumas84812333louma_s
mammals10389273mammals
modals93914463mo_dals
mommas94110653momma_s
moral75533433mor_al_
morale85220553mor_ale
morales93619403mor_ales
moras76438783mor_a_s
morass84614503mor_ass
morays114613883mor_ays
morels84820023mor_els
morgans10310123morgans
morsels94112663morsels
mortal84616853mortal_
mortars93411523mortars
morulas959723morulas
murals84016763mur_als
narwals1036983narwals
nomads94711603no_mads
nomas74726413no_ma_s
nopals84914023no_pals
norias65518203noria_s
normalcy1543383normalcy
normalise11259423normalise
normally1347883normally
norms76019313norm__s
offals1235893_offals
oorali6311263oor_ali
ooralis7312553oor_alis
opals75718353_o_pals
oral47638123_or_al_
orcas75918623_orca_s
ordeals878003_ordeals
oreads73915773_oreads
organs7912913_organs
oriels64914623_oriels
ormers84316143_ormers
ormolu845833_ormolu
ormolus934743_ormolus
osmols8137313_osmols
ovals85413393_o_vals
parrals94414573parrals
pommels13235793pommels
portal84218463portal_
postals93716383postals
reals55038653__reals
reformats1445713reformats
rials55026673__rials
romans84620243ro_mans
rorquals1773183rorquals
royals93711263ro_yals
serials73919753serials
servals103410753servals
socials999633socials
somans84619303so_mans
somas76030373so_ma_s
soras55041013sor_a_s
sorels63921163sor_els
sorrels7310723sorrels
tamals84116633_tamals
tarmacs1138323tarmacs
tarsals72512603tarsals
thermals13518533thermals
tomans85419133to_mans
torahs95115643tor_ahs
toras55540373tor_a_s
tortas64918253torta_s
torulas759853torulas
totals63115163to_tals
trials64319883_trials
urials64415193_urials
verbals121910743verbals
vocals113811583vo_cals
wadmals1335513wadmals
womans114613653wo_mans
wormers124012573wormers
wormil1138043wormil_
worms105320763worm__s
zorils153810883zor_ils

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273575.81323056.4
3Display Results3573570.1232902.4
 (SQL Overall)1786913576.34228175.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.