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

220 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
ferrous104979(None) 
ferreous1146031ferreous
cerous85821202ce_rous
cirrous93111062cirrous
errors63311312_errors
farrows13259782farrows
ferrels10248622ferrels
ferrets103111392ferrets
ferries103521082ferries
ferrum1147452ferr_um
ferrums1265982ferrums
fervors1336232fervors
fervour1343102fervour
fervours1453052fervours
feverous1446512feverous
fibrous1237592fibrous
furious103110632furious
furrows13327792furrows
leprous938842leprous
nervous1037142nervous
perrons93115482perrons
petrous92714422petrous
serious73616282serious
serous65023562se_rous
terrors73112212terrors
acerous9513333acerous
aeneous739893aeneous
amorous9311133amorous
anurous7311553anurous
arenous7314183arenous
arrows92813483_arrows
aurous64119263_aurous
barrows123411683barrows
berries94423553berries
borrows12349253borrows
burnous938823burnous
burros85114993burro_s
burrows12399093burrows
carious93320283carious
carroms11512403carroms
carrots9714623carrots
cercus105013153ce_rcus
cereus85215523ce_reus
cernuous1055013cernuous
ceros74726073ce_ro_s
cirrus8349173cirr_us
citrous93112993citrous
cormous11312353cormous
cuprous1149743cuprous
curious93813563curious
decorous1138853decorous
derries83124623derries
derris73615273derr_is
desirous947783desirous
devious1138523devious
dextrous1646593dextrous
ecrus75113863_ecr_us
enrols61213383_enrols
ergots74512373_ergots
eros45238453_e_ro_s
error53712233_erro_r
errs45622533_err__s
estrous7712533estrous
euros54920243_euro_s
famous11412393f_amous
faros85532023f_aro_s
farrow12309973farro_w
fatuous1037783fatuous
fearers104815273fearers
fearful1345593fearful
fears84829393fear__s
fedoras1137923fedoras
feijoas1742323feijoas
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
fenurons1174963fenurons
feods99516853fe__ods
ferals94216643fe_rals
ferbams1435743ferbams
feres86038183fe_r_es
ferias95020393fe_rias
ferlies103216693ferlies
fermions1336203fermions
fermis114313503fe_rmis
fermium1446353fermium
fermiums1544353fermiums
ferns85220083fe_r_ns
ferocious1445193ferocious
ferrate103014043ferrate
ferrates113013423ferrates
ferrel92810203ferr_el
ferret93021173ferr_et
ferrety13287013ferrety
ferric1139993ferr_ic
ferried113411523ferried
ferrite103312753ferrite
ferrites112312833ferrites
ferrule1035863ferrule
ferrules1136163ferrules
ferry116020803ferr__y
ferulas103110753ferulas
ferules103112723ferules
fervor1235643fervo_r
fetors91014473fe_tors
fetus85816543fe__tus
feus75830753fe___us
fleurons1155343fleurons
flexuous1842413flexuous
folious103710733folious
fordoes11311963fordoes
forgoes11311353forgoes
formols12299413formols
freres94716173frer_es
froes86126693f__roes
frogs96220773f__rogs
frons86124043f__rons
frows116623103f__rows
fucous11399863f_ucous
fulvous1334543fulvous
fungous11367433fungous
furores10310033furores
furors9310953f_urors
furrow12427743furro_w
furrowy16384473furrowy
fuscous1256673fuscous
garrons82713463garrons
generous939773generous
genros74211333genro_s
harrows132611033harrows
heinous1038853heinous
heriots10312063heriots
heroes94923823he_roes
herons94820543he_rons
heros84930863he_ro_s
herries104025073herries
horrors1078693horrors
hydrous14197883hydrous
jealous1438093jealous
jerboas1636163jerboas
jerrids15277743jerrids
jerries143817513jerries
karroos1139313karroos
kerrias11289513kerrias
kerries113317913kerries
marrons93216973marrons
marrows122911823marrows
meous76120063me__ous
mercurous1344473mercurous
merlons93311273merlons
merlots92710123merlots
metros84217803metro_s
mirrors938623mirrors
morros83714673morro_s
morrows12318723morrows
narrows10258843narrows
nerols6914883ne_rols
neurons7410443neurons
nitrous73512483nitrous
nonferrous1393743nonferrous
ochrous1237943ochrous
odorous837663odorous
oestrous869923oestrous
onerous7312973onerous
parlous9414293parlous
parous84024163_parous
parrots9312743parrots
pedros9312183pedro_s
pelorus939273pelorus
perdus93711273pe_rdus
pereons92815003pereons
perilous10310693perilous
periods10312243periods
peritus9311803peritus
pernods1038483pernods
perries93226603perries
perron83216623perro_n
persons93717013persons
pervious1337543pervious
petrols92913083petrols
pierrots1044963pierrots
porous84419483_porous
pyrrols1235403pyrrols
rearouse839363rearouse
recross989833recross
regroup1095173regroup
regroups11104383regroups
regrows11269153regrows
repros84216003repro_s
reroofs1037943reroofs
retros63820193retro_s
sarcous9312933sarcous
sermons9311783sermons
serows96016393se_rows
serries73925353serries
servos93812723servo_s
setous64917373se_tous
sorrows10278403sorrows
spermous1247933spermous
tedious838443tedious
tenuous738483tenuous
termors94712773termors
terras63516973terr_as
terrets72913583terrets
terries73425633terries
territs72714503territs
terror63811733terro_r
torous64319033_torous
various103113103various
venous93713193ve_nous
verdurous1343683verdurous
verrucous1442953verrucous
versos93812803verso_s
versus94211143ve_rsus
vertus94613603ve_rtus
xerus12313333xe_r_us
yarrows13277853yarrows
zealous1637813zealous
zeroes154314343ze_roes
zeros144918113ze_ro_s

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.436409841.7
2DLD Change Limit1340272206.11021935.7
3Display Results2202200.0802750.0
 (SQL Overall)1786912206.62626968.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.