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

344 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
prelims113982(None) 
prelim10311421prelim_
kelims1278912_kelims
prearms11369172prearms
prebids12399882prebids
precis103416702preci_s
prelife1279942prelife
prelimit1259122prelimit
prelimits1366012prelimits
prelives13310382prelives
premies113823062premies
premiss113513812premiss
premiums1437532premiums
pretrims1238982pretrims
prexies163415002prexies
prims95425932pr__ims
relics84517902_relics
relies65036422_relies
abelias93213563abelias
bedims1149593_bedims
belies84631053_belies
berlins93216013berlins
breams104815043bre_ams
brewis11469983brewi_s
brims94721623br__ims
celoms10412123_celoms
coeloms1139063coeloms
creams104715253cre_ams
credits1039973credits
cretics112911653cretics
cretins93216423cretins
delime9314043_delime
delimes10314193_delimes
delis64928543_deli_s
denims95214323_denims
dreams94513983dre_ams
elms67322703__el_ms
eyelids1135943eyelids
felids103111623_felids
ferlies103216693ferlies
forelimb1544083forelimb
forelimbs1642233forelimbs
frenums1236203frenums
frolics1236833frolics
glims87417673__glims
gremlins1136043gremlins
harelips1345213harelips
helios94816633_helios
heliums12188303_heliums
helms105619463_hel_ms
ireless72312243ireless
irenics937833irenics
kelim11912553_kelim_
kilims1277903_kilims
kremlins1444483kremlins
merlins93015813merlins
myelins1237353myelins
obelias9279033obelias
obelism1138203obelism
obelisms1236393obelisms
oralism9513763oralism
oralisms10610973oralisms
pablums1345123pablums
paellas9411413paellas
palliums1236703palliums
palms94921753p_al_ms
parecism1458533parecism
parecisms1547163parecisms
paresis93315093paresi_s
paretics122312443paretics
paulins9312613paulins
paynims1434973paynims
peelers93615593peelers
peeling102919873peeling
peelings11339523peelings
peels75226423peel__s
peeries93623023peeries
peewits12105873peewits
peins76128063p_e_ins
pekins121812233p_ekins
peles75738083p_el_es
pelfs105016293p_el_fs
pelisse967063p_elisse
pelite84323003p_elite
pelites93821993p_elites
pelts76128813p_el_ts
pelves114514663p_elves
pelvics14245643p_elvics
pelvis113610323p_elvis
penis75129323p_eni_s
peplums13145503peplums
perils84121853p_erils
peris75537073p_eri_s
perlite9317323perlite
perlites10316363perlites
permits11314003permits
perms95524513p_e_rms
perries93226603perries
pewits112810683p_ewits
phellems1544543phellems
phenoms1437813phenoms
phlegms1542373phlegms
pieties9419223pieties
pietism1139113pietism
pietisms1247463pietisms
pilis75825203p_ili_s
plenism11310113plenism
plenisms1237963plenisms
plenums1136533plenums
plies74526513p__lies
plums94619953p__lums
poems95715553poe__ms
poesies93217403poesies
poetics11312073poetics
poleis86018353polei_s
polies84034583p_olies
polios84019723p_olios
polis74731163p_oli_s
poplins11313153poplins
praams10459643pr_aams
praline93019743praline
pralines102217723pralines
prams96125513pr__ams
praxis154012253praxi_s
preacts113211363preacts
preamp1238993pre_amp
preamps1336613preamps
prearm104512353prearm_
prebid113512843prebi_d
prebill1138803prebill
prebills1237293prebills
prebind123810643prebind
prebinds13357733prebinds
prebless1236823prebless
preboils1267293preboils
prebuys1444393prebuys
precess11310863precess
precious12310593precious
precipe133012123precipe
precipes143212213precipes
precise113518173precise
precises123218333precises
precuts111710473precuts
predial103815413predial
predict12315323predict
predicts1339613predicts
predive13511083predive
predries112714383predries
preedits1168763preedits
preeing103817673preeing
preemie11310563preemie
preemies12512193preemies
preens85020113pre_ens
prees75937173pre__es
prefabs1435163prefabs
prefers123713333prefers
prefile123413183prefile
prefiles133113443prefiles
prefire124012813prefire
prefires134313283prefires
prefix18356853prefi_x
prefixes20389233prefixes
preflame1545913preflame
preforms1537403preforms
pregame1239553pregame
pregames1339003pregames
prelacies13310053prelacies
prelacy1437583prelacy
prelate9519693prelate
prelates10418573prelates
prelatism1347853prelatism
prelatisms1445703prelatisms
prelaw1139103prel_aw
prelect111013833prelect
prelects1299723prelects
preload1049813preload
preloads1157513preloads
prelude1038013prelude
preludes1137833preludes
premeds12389593premeds
premie103617993premi_e
premier113515633premier
premiers122911653premiers
premise113818553premise
premises123018273premises
premium13310363premium
premix173710333premi_x
premixes193110083premixes
premixt183510663premixt
prename11412643prename
prenames12311643prenames
preops104911943pre_ops
prepays1437483prepays
prepill1147583prepill
preplans1249613preplans
preppies1149683preppies
preps96220693pre__ps
prerinse1038633prerinse
preriot9316413preriot
presets94216423presets
preships1539313preships
preside10715613preside
presides11414913presides
presift12312223presift
presifts1366593presifts
preslice1258623preslice
preslices1338213preslices
press75425953pre__ss
presses93523153presses
prestos93716083prestos
prests84021263pre_sts
presume11310303presume
presumes1239843presumes
preterms1237223preterms
pretors9316813pretors
pretrim11310783pretrim_
pretties10615133pretties
prevails1337663prevails
preview1536473preview
previews1634513previews
previous1337823previous
previse123713793previse
previses133814283previses
prevues1239263prevues
prewarms15406733prewarms
prewire124311143prewire
prewires133811013prewires
prexes154915953pre_xes
preyers124412363preyers
preying133114553preying
preys105717783pre__ys
prezes173614693pre_zes
pries74339533pr__ies
prigs85219703pr__igs
prills84015613pril_ls
prim85132203pr__im_
prima95019343pr__ima
primas104418103pr__imas
prime96525603pr__ime
primes104225263pr__imes
primi95017403pr__imi
primo95017913pr__imo
primos104514423pr__imos
primp115615923pr__imp
primps124711823pr__imps
primus103712173pr__imus
prism94820263pr__ism
prisms104915503pr_isms
priss74623893pr__iss
privies122414263privies
probits112712573probits
problems1434343problems
proclaims1545073proclaims
proems104711163pr_oems
profits122911243profits
prolans9314273prolans
prolegs10379993prolegs
proles84627203prol_es
proline92321593proline
prolines102619693prolines
prolix1538683proli_x
prologs103512133prologs
proms95426413pr__oms
protiums1238553protiums
proxies163014933proxies
proximo1845143proximo
psalms1045673psal_ms
pterins9812993pterins
publics13207143publics
pulis74225603p_uli_s
purlins93415423purlins
pyelitis1346583pyelitis
pyemias1436803pyemias
pyralids1445813pyralids
pyrexias20224993pyrexias
realism93115923_realism
realisms102212163_realisms
realms84913493_realms
reams75729623_re_ams
rearms85114653_rearms
rebids94015533_rebids
recits83621353_recits
reclaims1236113_reclaims
redias74523603_redias
redips93713843_redips
refilms12347503_refilms
refits94017653_refits
reflies104418533_reflies
regime95313943_regime
regimes104514743_regimes
regius7311923_regius
rehems113410983_rehems
reifs84819093_re_ifs
reins56234563_re_ins
reis45343233_re_i_s
rejigs14368093_rejigs
relays94316753_relays
relets64025673_relets
relic74623363_reli_c
relict83623903_relict
relicts94414593_relicts
relied74926233_relied
relief94419683_relief
reliefs10439433_reliefs
relier65826183_relier
reliers75519213_reliers
reline65434353_reline
relines75331323_relines
relink104415923_relink
relinks114510223_relinks
relish93916953_relish
relist64628413_relist
relists73817053_relists
relit55340683_reli_t
relive95120783_relive
relives104619443_relives
relume8313273_relume
relumes9612513_relumes
remiss84216353_remiss
remits85622943_remits
rems66237723_re__ms
renigs74314593_renigs
renins64526453_renins
reoils64516873_reoils
repins84924313_repins
replies94521043_replies
rerigs74014793_rerigs
resids74219153_resids
resins64528773_resins
resits64725563_resits
retems83914573_retems
reties65436193_reties
retime85321803_retime
retimes95020173_retimes
retrims93612373_retrims
rewins95020823_rewins
rims65936303_r__ims
skelms12368023skel_ms
slims75423653__slims
trellis739873trellis
trims75021473tr__ims
uremias9249503uremias
whelms14377573whel_ms
yeelins1038813yeelins

Search took 8 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.453394461.4
2DLD Change Limit1340273447.20318607.1
3Display Results3443440.1232796.7
 (SQL Overall)1786913447.77922970.9
 
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.