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

171 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
ferrums126598(None) 
ferrum1147451ferrum_
ceriums1139472ceriums
ferbams1435742ferbams
fermiums1544352fermiums
ferrels10248622ferrels
ferrets103111392ferrets
ferries103521082ferries
ferrous1049792ferrous
ferrule1035862ferrule
ferrules1136162ferrules
forums114611842f_orums
frenums1236202frenums
serums83916302se_rums
alarums9408923alarums
antrums969173antrums
arums75517833__arums
asarums9467613asarums
atriums939043atriums
aurums849383_aurums
bariums1139143bariums
bedrugs11194283bedrugs
begrims1276763begrims
begums11429493be_gums
berms95323663be_r_ms
berries94423553berries
carroms11512403carroms
centrums1236913centrums
centums11398783centums
cercus105013153cercu_s
cerebrums1542903cerebrums
cereus85215523cereu_s
cerium10313763cerium_
cerous85821203cerou_s
cesiums1136303cesiums
chetrums1543913chetrums
cirrus8349173cirru_s
cuprums1334453cuprums
curiums1138503curiums
decorums1344993decorums
degums10438623de_gums
derms85022893de_r_ms
derries83124623derries
derris73615273derr_is
dirdums1134383dirdums
drums85415873__drums
durums948153_durums
eardrums11524483eardrums
ecrus75113863_ecru_s
erbiums1135463_erbiums
errors63311313_errors
errs45622533_err__s
estrums9208603estrums
fanums1137263f_anums
farms106324953f_ar_ms
farrows13259783farrows
fearers104815273fearers
fears84829393fear__s
fems96428703fe___ms
femurs1136713fe_murs
ferals94216643fe_rals
ferbam1339003ferbam_
feres86038183fe_r_es
ferias95020393fe_rias
ferlies103216693ferlies
fermi103914163fe_r_mi
fermis114313503fe_rmis
fermium1446353fermium_
ferns85220083fe_r_ns
ferrate103014033ferrate
ferrates113013403ferrates
ferrel92810203ferr_el
ferreous1146033ferreous
ferret93021173ferr_et
ferrety13287013ferrety
ferric1139993ferr_ic
ferried113411523ferried
ferrite103312753ferrite
ferrites112312823ferrites
ferruled1263923ferruled
ferry116020803ferr__y
ferryman1643803ferryman
ferrymen1643933ferrymen
ferula93011173fe_rula
ferulas103110753ferulas
ferule93413203fe_rule
ferules103112723ferules
fervors1336233fervors
fervours1453053fervours
fescues1236783fescues
fetus85816543fe_tu_s
feuds95914883fe__uds
feus75830753fe__u_s
firms105217423f_ir_ms
foliums1237173foliums
forams115115913f_orams
foreruns1146623foreruns
forms105327053f_or_ms
forum108318763f_orum_
frauds1036753f_rauds
frenum1188803frenum_
freres94716173frer_es
frugs96114283f__rugs
frump126912563f__rump
frumps13479783f__rumps
fulcrums1542353fulcrums
furrows13327793furrows
germs85118873ge_r_ms
geums85414113ge__ums
heliums12188303heliums
herms105626433he_r_ms
herries104025073herries
jerrids15277743jerrids
jerries143817513jerries
jorums15408093_jorums
kerrias11289513kerrias
kerries113317913kerries
labrums1175853labrums
larrups934733larrups
larums83610533_larums
marrams11310123marrams
mediums12308723mediums
megrims1276103megrims
neums75414253ne__ums
oestrums10156463oestrums
overruns1138173overruns
peplums13145503peplums
percuss1137163percuss
perdues103511333perdues
perdus93711273perdu_s
perfume1446503perfume
perfumes1555893perfumes
perfumy1763933perfumy
perms95524513pe_r_ms
perries93226603perries
perrons93115483perrons
quorums1843893quorums
rearms85114653rear_ms
rectums11338523rectums
reruns66413743re_runs
retrims93612373retrims
rums64833473___rums
sacrums11388043sacrums
scrums104614253_scrums
sebums10369813se_bums
sedums93910483se_dums
septums1135743septums
serous65023563serou_s
serries73925353serries
serum75223473se_rum_
sternums1045783sternums
strums84716453_strums
tectums11306423tectums
tediums10266973tediums
terbiums1245423terbiums
tergum937933tergum_
terms75523473te_r_ms
terras63516953terr_as
terrets72913573terrets
terries73425613terries
territs72714493territs
terrors73112203terrors
thrums11429123_thrums
vellums1235293vellums
veratrums1443343veratrums
verisms123011253verisms
verruca1243713verruca
verrucas1343923verrucas
versus94211143versu_s
vertus94613603vertu_s
xerus12313333xe_ru_s

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 Filter1786911340270.203880251.2
2DLD Change Limit1340271715.65623696.4
3Display Results1711710.0463717.4
 (SQL Overall)1786911715.90530261.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.