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

209 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
ferrum114745(None) 
ferrums1265981ferrums
cerium10313762cerium
ferbam1339002ferbam
fermium1446352fermium
ferrel92810202ferrel
ferret93021172ferret
ferric1139992ferric
ferrous1049802ferrous
ferrule1035862ferrule
ferry116020802ferr_y
forum108318762f_orum
frenum1188802frenum
serum75223472se_rum
tergum937932tergum
aecium10410423aecium
alarum85411983alarum
antrum8611313antrum
arum66129033__arum
asarum84610913asarum
atrium8411823atrium
aurum7614963_aurum
barium10313513barium
bedrug10164953bedrug
begrim11118333begrim
begum105213923be_gum
berm86732753be_r_m
berry104521773berr_y
carrom10513403carrom
cecum11611843ce_cum
centrum1168603centrum
centum104012363centum
cercus105013153cercus
cerebrum1443793cerebrum
cereus85215523cereus
ceriums1139473ceriums
cerous85821203cerous
cesium1039583cesium
chetrum1445343chetrum
cirrus8349173cirrus
corium10315723corium
cuprum1236743cuprum
curium10312503curium
decorum1246943decorum
degum94711903de_gum
derm76031893de_r_m
derris73615273derris
derry94721373derr_y
dirdum1036033dirdum
dorsum947623dorsum
drum76521593__drum
durum8513203_durum
eardrum10135423eardrum
ecru65819533_ecru_
ecrus75113863_ecrus
erbium1038083_erbium
err35626533_err__
erratum944513_erratum
erred65915673_erred
error53712233_error
errs45622533_err_s
estrum81810513estrum
fanum10313443f_anum
farm95934533f_ar_m
farrow12309973farrow
fear75337793fear__
feared106320433feared
fearer94820183fearer
fearful1345593fearful
fears84829393fear_s
feirie939553feirie
fem86040733fe___m
femur1038683fe_mur
femurs1136713femurs
fer66646123fe_r__
feral85424653fe_ral
ferals94216643ferals
ferbams1435743ferbams
fere76342233fe_r_e
feres86038183fe_res
feria85922713fe_ria
feriae95618603feriae
ferial94621253ferial
ferias95020393ferias
ferine96422583ferine
ferity122813343ferity
ferlie92814053ferlie
ferly115517353fe_rly
fermi103914163fe_rmi
fermis114313503fermis
fermiums1544353fermiums
fern76129323fe_r_n
ferns85220083fe_rns
ferny115816183fe_rny
ferrate103014043ferrate
ferrels10248623ferrels
ferreous1146043ferreous
ferrets103111393ferrets
ferrety13287013ferrety
ferried113411523ferried
ferries103521083ferries
ferrite103312753ferrite
ferruled1263923ferruled
ferrules1136163ferrules
ferryman1643813ferryman
ferrymen1643943ferrymen
ferula93011173ferula
ferule93413203ferule
fervid1337513fervid
fervor1235643fervor
fervour1343103fervour
fescue1137493fescue
fetus85816543fe_tus
feu67843663fe__u_
feud86523023fe__ud
feus75830753fe__us
filum105015433f_ilum
firm96026453f_ir_m
firry115713533firr_y
folium11310453folium
foram105124933f_oram
forerun1037653forerun
form95836873f_or_m
forrit91916623forrit
forums114611843f_orums
fraud939863f_raud
frenums1236203frenums
frere85617723frer_e
freres94716173freres
from96923923f__rom
frug86517103f__rug
frump126912563f__rump
fulcrum1443483fulcrum
furfur1235553furfur
furred104514433furred
furrow12427743furrow
furry116719283furr_y
germ75428963ge_r_m
geum75424553ge__um
grum75625083__grum
helium112311253helium
herm95636153he_r_m
herry114922473herr_y
iterum837903iterum
jerrid14259143jerrid
jerry155016183jerr_y
jorum145513743_jorum
kerria10339913kerria
kerry124916093kerr_y
labrum1057423labrum
larrup835713larrup
larum74317973_larum
marram10313883marram
medium113711623medium
megrim1178043megrim
mentum104511713mentum
merry104721493merr_y
neum66723083ne__um
oestrum9177783oestrum
overrun1038023overrun
peplum12156823peplum
perdu84216273perdu_
perdue93912633perdue
perdus93711273perdus
perfume1446503perfume
perfumy1763933perfumy
perm85834633pe_r_m
perron83216623perron
perry105222713perr_y
quorum1736023quorum
rearm75923573rear_m
rectum103411283rectum
regnum957163regnum
rerun58722153re_run
retrim83514883retrim
rum56644643___rum
sacrum103910143sacrum
scrum95418203_scrum
sebum93814553se_bum
sedum84115573se_dum
sensum849353sensum
septum1038003septum
serous65023563serous
serry84824123serr_y
serums83916303se_rums
sternum947733sternum
strum75619453_strum
tectum10328603tectum
tedium9269873tedium
telium82611393telium
terbium1147293terbium
term66233153te_r_m
terra54419663terr_a
terrae62915213terrae
terras63516973terras
terret63425623terret
territ63421373territ
terror63811733terror
terry84721873terr_y
thrum104713633_thrum
vellum1136773vellum
velum10713383ve_lum
veratrum1344313veratrum
verism113214263verism
verruca1243713verruca
versus94211143versus
vertu85017613vertu_
vertus94613603vertus
xerus12313333xe_rus

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.373479064.3
2DLD Change Limit1127162095.62620034.8
3Display Results2092090.0633317.5
 (SQL Overall)1786912096.06229477.2
 
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.