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

353 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
prelim1031142(None) 
prelims1139821prelims
kelim11912552_kelim
prearm104512342prearm
prebid113512842prebid
precis103416702precis
prefix18356852prefix
prelaw1139102prelaw
prelife1279942prelife
prelimit1259122prelimit
premie103617992premie
premium13310362premium
premix173710332premix
pretrim11310782pretrim
prim85132202pr__im
prolix1538682prolix
relic74623362_relic
relit55340682_relit
abelia83114403abelia
aphelia1249423aphelia
areic73219393are_ic
atelic8313703atelic
baalim1038473baalim
bedim10313833_bedim
belie75630383_belie
berlin83116373berlin
bream95121813bre_am
brewis11469983brewis
brim85629373br__im
celom9515683_celom
coelom10310423coelom
cream95721343cre_am
credit9315193credit
cretic102816283cretic
cretin82917913cretin
deli55631293_deli_
delime9314043_delime
delis64928543_delis
denim85518843_denim
dream85120393dre_am
elm57531743__el_m
eyelid1038443eyelid
felid94717173_felid
ferlie92814053ferlie
firelit10310863firelit
forelimb1544083forelimb
frenum1188803frenum
frolic1149203frolic
gelid74916983_gelid
glim76026353__glim
gremlin1035563gremlin
grim76929423gr__im
harelip1245953harelip
helio85321193_helio
helium112311253_helium
helix154413013_helix
helm95530023_hel_m
irenic8311103irenic
kelims1278913_kelims
kilim11711893_kilim
kremlin1344213kremlin
melic94722333_melic
merlin83916683merlin
mohelim1444763mohelim
myelin1138973myelin
obeli73711933obeli_
obelia8329453obelia
obelism1138203obelism
oralism9513763oralism
pablum1237503pablum
paella8410913paella
pallia83015593pallia
pallid93915283pallid
pallium1149013pallium
palm85331363p_al_m
parecism1458533parecism
paresis93315093paresis
paretic113016673paretic
parhelia1346713parhelia
parhelic1547093parhelic
passim10410283passim
paulin8312983paulin
paynim1337363paynim
peel65535613peel__
peeled94119703peeled
peeler83517383peeler
peeling102919873peeling
peels75226423peel_s
peerie83617893peerie
peewit111110903peewit
pein65834943p_e_in
pekin111514423p_ekin
pele65539553p_el_e
peles75738083p_eles
pelf97031453p_el_f
pelfs105016293p_elfs
pelite84323003p_elite
pelon74423213p_elon
pelt67651083p_el_t
pelts76128813p_elts
pelvic13307553p_elvic
pelvis113610323p_elvis
penis75129323p_enis
peplum12156823peplum
perdie94718513perdie
pereia85217983pereia
peri65636973p_eri_
peril75425953p_eril
perils84121853perils
peris75537073p_eris
perlite9317313perlite
perm85834633p_e_rm
permit10321683permit
pernio8513143pernio
petit74332653p_etit
pewit104622793p_ewit
phellem1435833phellem
phenix1837133phenix
phenom1339473phenom
phlegm1433093phlegm
phrenic1438773phrenic
phylic16279553phylic
phylum1655153phylum
pietism1139113pietism
pilei74021783pilei_
pileum10399513pileum
pili66130353p_ili_
pilis75825203p_ilis
plenism11310113plenism
plenum1039503plenum
plie65127393p__lie
plum85122103p__lum
poem86225773poe__m
poetic10416843poetic
poleis86018353poleis
polio75722553p_olio
polis74731163p_olis
poplin10413483poplin
praam94815613pr_aam
praline93019743praline
pram85733493pr__am
praxis154012253praxis
preach133613923preach
preact103220393preact
preamp1238993preamp
prearms11369173prearms
prebids12399883prebids
prebill1138803prebill
prebind123810643prebind
preboil1148953preboil
preboom1348243preboom
prebuy1357423prebuy
precipe133012123precipe
precise113518173precise
precut102016533precut
predial103815413predial
predict12315323predict
predive13511083predive
predry1237863predry
pree67044733pre__e
preed85128113pre_ed
preedit10512453preedit
preeing103817673preeing
preemie11310563preemie
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefab1336243prefab
prefer113813203prefer
prefile123413183prefile
prefire124012813prefire
preflame1545913preflame
preform1439603preform
pregame1239553pregame
prelacy1437583prelacy
prelate9519693prelate
prelatic12311283prelatic
prelatism1347853prelatism
prelect111013833prelect
prelimits1366013prelimits
prelives13310383prelives
preload1049813preload
prelude1038013prelude
preman104117453preman
premed114617753premed
premen105017803premen
premier113515633premier
premies113823063premies
premise113818553premise
premiss113513813premiss
premiums1437533premiums
premixt183510663premixt
prename11412643prename
preop94715873pre_op
preops104911943preops
prep86427673pre__p
prepaid12310133prepaid
prepay13310313prepay
prepill1147583prepill
preplan1149953preplan
preppie1058093preppie
preppy1235523preppy
preps96220693pre_ps
preriot9316413preriot
presa74319043pre_sa
prese75228383pre_se
preset84430983preset
preship1439793preship
preside10715613preside
presift12312223presift
preslice1258623preslice
presplit1247753presplit
press75425953pre_ss
prest75736353pre_st
presto84216203presto
prests84021263prests
presume11310303presume
pretax152310193pretax
preterm11310153preterm
pretor8315743pretor
pretrims1238983pretrims
pretty11510873pretty
prevail1238243prevail
preview1536473preview
previse123713793previse
prevue1179163prevue
prewar114712573prewar
prewarm14479603prewarm
prewire124311133prewire
prex135722973pre__x
prexes154915943prexes
prexies163415003prexies
prexy174611573pre_xy
prey96228483pre__y
preyed125313193preyed
preyer114413733preyer
preying133114553preying
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
prig75924873pr__ig
prill74117943pril_l
prills84015613prills
prima95019343pr__ima
prime96525603pr__ime
primi95017403pr__imi
primo95017913pr__imo
primp115615923pr__imp
prims95425933pr__ims
prism94820263pr_ism
probit103218353probit
problem1335983problem
proclaim1446073proclaim
proem94818273pr_oem
profit113016273profit
prolan8414693prolan
prole74527793prol_e
proleg94612113proleg
proles84627203proles
proline92321593proline
prolog94212973prolog
prom87631703pr__om
prosit85124593prosit
protium11312293protium
proximo1845143proximo
psalm949273psal_m
pterin81014153pterin
public12238143public
puli65527623p_uli_
pulik113613303p_ulik
pulis74225603p_ulis
purely114013623purel_y
purlin83615863purlin
pyemia1337553pyemia
pyemic1537893pyemic
pyralid1347983pyralid
pyretic143210783pyretic
pyrexia19225463pyrexia
pyrexic21235353pyrexic
realia6314593_realia
realism93115923_realism
realm75621623_realm
ream65841613_re_am
rearm75923563_rearm
rebid85121363_rebid
recit75235103_recit
reclaim1137753_reclaim
redia65524483_redia
redid74922393_redid
redip87816963_redip
refilm114311403_refilm
refit84230063_refit
refix155212483_refix
regime95313943_regime
rehem103815353_rehem
rei35647253_re_i_
reif76937653_re_if
rein46040893_re_in
reis45343233_re_is
rejig133810123_rejig
relaid75518443_relaid
relax124817803_relax
relay84424673_relay
relet54749823_relet
relics84517903_relics
relict83623903_relict
relied74926233_relied
relief94419683_relief
relier65826183_relier
relies65036423_relies
reline65434353_reline
relink104415923_relink
relish93916953_relish
relist64628413_relist
relive95120783_relive
relume8313273_relume
rely75428953_rel_y
rem56150043_re__m
remit75737223_remit
remix145916553_remix
renig64518913_renig
renin54830033_renin
reoil55321183_reoil
repin75324703_repin
rerig64018483_rerig
resid64124093_resid
resin54131053_resin
resit54241043_resit
retem74221953_retem
retia55326113_retia
retie55735303_retie
retime85321803_retime
retrim83514883_retrim
rewin85623963_rewin
rim56052273_r__im
skelm114211293skel_m
slim66631963__slim
stelic8313083stelic
telia55821143_telia
telic76019823_telic
telium82611393_telium
trellis739873trellis
trepid9310083trepid
trim65329523tr__im
uredia73610063uredia
uredium1076693uredium
ureic74514463ure_ic
uremia82910893uremia
uremic103410513uremic
uretic82914353uretic
velum10713383_velum
whelm134611983whel_m
yeelin939343yeelin

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 Filter1786911127160.1231452772.4
2DLD Change Limit1127163535.57620214.5
3Display Results3533530.1103209.1
 (SQL Overall)1786913535.80930761.1
 
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.