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

213 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
frenum118880(None) 
fraenum1255701fraenum
frenums1236201frenums
crinum1039332crinum
fanum10313442f_anum
ferrum1147452ferrum
fraenums1353402fraenums
frena85915272fren_a
french143511212french
frenula1045622frenula
frenulum1342612frenulum
frenzy2135882frenzy
granum9310912granum
plenum1039502plenum
regnum957162_regnum
acetum1038463acetum
agendum1144673agendum
arcanum1176443arcanum
arena55323813aren_a
arenas65022013arenas
arene55329413aren_e
arenes64928393arenes
arenous7314183arenous
argentum1145363argentum
arum66129033ar__um
avenue957953avenue
begum105213923_begum
benumb1235773_benumb
bream95121813bre_am
bren65629563bren__
brens75823363bren_s
brent75734133bren_t
brents84717283brents
caecum1238183caecum
cecum11611843_cecum
centum104012363_centum
cerium10313773cerium
cranium11911103cranium
cream95721353cre_am
crenel84213063crenel
crinums1135863crinums
degum94711903_degum
denim85518843_denim
dream85120393dre_am
drench12369593drench
drum76521593dr__um
enuf7323843__enuf
erbium1038083erbium
erenow937373erenow
faena85014203faen_a
faenas94412763faenas
fanums1137263f_anums
fem86040733f_e__m
femur1038683f_emur
fen66851353f_en__
fence105319913f_ence
fend84832973f_en_d
fends96324973f_ends
fenny115115133f_enny
fens76139763f_en_s
ferbam1339003ferbam
fermium1446353fermium
fern76129323fern__
ferns85220083fern_s
ferny115816183fern_y
ferrums1265983ferrums
fetus85816543f_etus
feu67843663f_e_u_
feud86523023f_e_ud
feus75830753f_e_us
fiend95312983fien_d
fiends104110293fiends
filum105015433f_ilum
firearm1237203firearm
firebug1383793firebug
fleam106017283fle_am
flench144010813flench
flense938903flense
foetus958523foetus
folium11310453folium
forearm1238703forearm
foregut1149163foregut
forename1347853forename
forerun1037653forerun
forum108318763f_orum
fraena938063fraen_a
franc104615413fran_c
francium1545623francium
francs114112193francs
frank124417513fran_k
franks134912733franks
fraud939863fr_aud
freak125115243fre_ak
freaks134713063freaks
freaky16439233freaky
free75940183fre__e
freed95223543fre_ed
freedom1345863freedom
freely12310963freely
freer86021243fre_er
freers94717303freers
frees86131393fre_es
freest95318283freest
freeze18349513freeze
fremd115010323fre_md
frenular1144633frenular
frenulums1441993frenulums
frere85617723fre_re
freres94716173freres
fresco1136473fresco
fresh115012203fre_sh
fresnel1035893fresnel
fret75845043fre__t
fretful1346143fretful
frets85523403fre_ts
fretty1249223fretty
friend10388933frien_d
friends11396743friends
fringe104013953fringe
fringy13309263fringy
from96923923fr__om
frond95316343fron_d
fronds106412343fronds
frons86124043fron_s
front85029223fron_t
fronts94415793fronts
frug86517103fr__ug
frump126912563fr__ump
frustum1243953frustum
genom83716843_genom
genu55929073_genu_
genua64614153_genua
genus65319833_genus
gerenuk1243843gerenuk
geum75424553_ge_um
grum75625083gr__um
ileum74512823ile_um
ireful948713ireful
irenic8311103irenic
iterum837903iterum
kronur10415313kronur
linum7313823_linum
magnum1136733magnum
mentum104511713_mentum
menu65130233_menu_
menus75822843_menus
neum66723083_ne_um
odeum84610543ode_um
oleum73613323ole_um
omentum1155933omentum
organum1045343organum
phenom1339473phenom
plenums1136533plenums
prearm104512353prearm
prebuy1357423prebuy
precut102016533precut
prelim10311433prelim
premium13310363premium
prename11412643prename
presume11310303presume
prevue1179163prevue
prunus8399363prunus
realm75621623_realm
ream65841613_re_am
rearm75923573_rearm
rebus75721113_rebus
rebut75927383_rebut
rebuy104714683_rebuy
rectum103411283_rectum
recur74116843_recur
recut74729243_recut
redub84212413_redub
redux133811103_redux
rehem103815353_rehem
relume8313273_relume
rem56150043_re__m
renal55929513_renal
rename82718813_rename
rend56136573_ren_d
rends65129953_rends
renew83917513_renew
renig64518913_renig
renin54830033_renin
rent46661243_ren_t
rente54733783_rente
rents55935183_rents
repump1235683_repump
rerun58722153_rerun
resume8313783_resume
retem74221953_retem
revue81114453_revue
rhenium1246243rhenium
rheum1038843_rheum
rum56644643_r__um
sebum93814553_sebum
sedum84115573_sedum
sensum849353_sensum
serum75223473_serum
sternum947733sternum
tergum937933tergum
trench114211613trench
trend64817453tren_d
trends75513543trends
trendy10469603trendy
uranium9610023uranium
uredium1076693uredium
velum10713383_velum
venom103914863_venom
venue84918213_venue
venus84918903_venus
wren78221683wren__
wrench14439353wrench
wrens85016243wren_s

Search took 9 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.403443402.0
2DLD Change Limit1127162137.12615817.6
3Display Results2132130.470453.2
 (SQL Overall)1786912137.99922339.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.