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

263 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
femora114958(None) 
fedora1038591fedora
femoral1238721femoral
remora8414591remora
fedoras1137922fedoras
femur1038682femur_
femurs1136712femurs
fetor81214532fetor_
fetors91014472fetors
flora85317102f_lora
fora75937392f__ora
memory1338802memory
mora66641272__mora
remoras9314072remoras
senora63216162senora
agora6914333_agora
amoral8314633_amoral
amort75832203_amort
angora71111573angora
armor75118053armor_
armors85017813armors
armory114211473armory
atemoya1242933atemoya
aurora6411763aurora
before11410153before
begorah1355593begorah
begorra1043543begorra
bema85825253bem__a
bemata10411693bemata
bemire103312803bemire
bemoan10310253bemoan
bemock1636173bemock
bevor101510813bevor_
bevors111610343bevors
beworm1339993beworm
bezoar1736913bezoar
bora66141633__bora
camera10313693camera
camorra11115763camorra
centra84113883centra
ceorl7410923ce_orl
cesura838763cesura
decor84717573decor_
decors94017773decors
deform1259623deform
dehorn10439653dehorn
dehort104618103dehort
demark134211023demark
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
democrat1347943democrat
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
demur8311163demur_
demure9311533demure
demurs939773demurs
deport94922393deport
desorb95210203desorb
deworm1249533deworm
dhoora1035653dhoora
effort1238623effort
embar94011603_embar
emery104814333_emery
emir65918703_emir_
emirs76116163_emirs
emote75421193_emote
emporia1148753_emporia
enorm74415643_enorm
era35741503_e__ra
extra1239003_extra
eyra76217553_e_yra
famous11412393famous
favor114712453favor_
favors124211403favors
fear75337793fe_ar_
fears84829393fe_ars
fecula113310053fecula
federal1148533federal
feijoa1642223feijoa
fella84918653fe_lla
felon84619293felo_n
felonry13294843felonry
felons93615763felons
felony123710323felony
felwort13410583felwort
fem86040733fem___
female11310553female
feme96130543fem__e
femes105626223fem_es
femme125011433fem_me
femmes135410213femmes
fems96428703fem__s
feod815523003fe_o_d
feods99516853fe_ods
feoff10711053fe_off
fer66646123fe__r_
feral85424653fe__ral
fere76342233fe__re
feria85922713fe_ria
fermata12278143fermata
fern76129323fe__rn
ferry116020803fe_rry
ferula93011173ferula
fervor1235643fervor_
fervors1336233fervors
feta76528903fe__ta
feuar8310243feuar_
feuars938653feuars
fever115617953fever_
fevers125414893fevers
fewer115216123fewer_
feyer115014523feyer_
fimbria1444453fimbria
fiord94313343f_iord
fjord16477023f_jord
flexor1634503flexor_
flexors1734773flexors
floor84215233floor_
floors94112353floors
florae94713883f_lorae
floral94313813f_loral
floras94715693f_loras
flota85315643f_lota
fluor84512773fluor_
fluors94311373fluors
foetor939563foetor_
foetors1039763foetors
for66952073f__or_
foram105124933f__oram
foray115023973f__oray
forb97131333f__orb
ford86835493f__ord
fore78351473f__ore
fork115930943f__ork
form95836873f__orm
fort76456443f__ort
frore86218803f_rore
fulcra1135213fulcra
fumer105918233fumer_
fumers113613383fumers
furor8312393furor_
furore9410013furore
furors9310953furors
gemma106311773gem_ma
gemot84024233gemo_t
gemote94613023gemote
gemots93712153gemots
genera71211713genera
genoa64315823geno_a
hegira1036523hegira
hejira1644803hejira
hemiola12107003hemiola
hemoid12313513hemoid
hora76136563__hora
humor101110513humor_
humoral1237973humoral
humors11129633humors
immoral1146783immoral
ixora1236913_ixora
kora86431553__kora
lemma94811033lem_ma
lemon75618183lemo_n
lemons84415053lemons
lemony11419553lemony
lempira1144193lempira
lemur739773lemur_
lemurs837253lemurs
mara67444573__mara
megara9310093megara
memo85924793memo__
memoir1037213memoir
memoirs1136803memoirs
memorial1249523memorial
memos95719113memo_s
menorah1247933menorah
mimosa1036363mimosa
moa57249183__mo_a
moira71012023__moira
mola66035633__mola
mor56855003__mor_
morae75831193__morae
moral75533433__moral
moras76438783__moras
moray105423793__moray
more67154523__more
morn66237563__morn
mors65950063__mors
mort66758833__mort
moxa136917743__moxa
mura65633303__mura
nema65522523nem__a
ora37250833___ora
oxymora1942653oxymora
pakora1247283pakora
peloria9310953peloria
pelota8612833pelota
peroral9314793peroral
premoral1249713premoral
ramona8412413ramona
rebore86625653rebore
reborn810016963reborn
record96117433record
recork126315493recork
redowa1038453redowa
reform11312713reform
remark123512373remark
remold93412973remold
remorid10311863remorid
remorse9311713remorse
remote84222603remote
removal1236733removal
remove116115573remove
remuda936823remuda
report85326023report
resorb84914353resorb
resort65728623resort
retore67630773retore
retorn610923433retorn
retort66831153retort
reword106321413reword
rewore938030163rewore
rework136619793rework
reworn98122203reworn
rumor71011323rumor_
rumors81110403rumors
samara8313853samara
samosa8510203samosa
semina8915563semina
semiraw1246053semiraw
sempre102710093sempre
senhora10348673senhora
senor53822803senor_
senoras72714953senoras
senors63620793senors
sera46141393se__ra
serosa6313023serosa
sora45746913__sora
tempera11329043tempera
temporal1246333temporal
tempura11295253tempura
tenor53620253tenor_
tenors63217753tenors
tephra1136483tephra
termor84412513termor_
termors94712773termors
terra54419663te_rra
tetra53417953te_tra
tora47545993__tora
tremor84210403tremor_
tremors93711233tremors
tumor71110693tumor_
tumoral938133tumoral
tumors8810613tumors
umbra948513_umbra
unmoral948693unmoral
vera76828843ve__ra
womera11137593womera
zebra1637883ze_bra

Search took 6 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.373479064.3
2DLD Change Limit1127162634.64324276.5
3Display Results2632630.0763460.5
 (SQL Overall)1786912635.09235092.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.