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

240 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
premeal1131051(None) 
gremial1039152gremial
preanal9310712preanal
predial103815412predial
preheat12413892preheat
prelegal1145042prelegal
preman104117452prem_an
premed114617752preme_d
premeds12389582premeds
premeet11615152premeet
premen105017802preme_n
premoral1249712premoral
preoral9312672preoral
prerenal1049082prerenal
presell939292presell
pretell938232pretell
primal104014622prim_al
primeval1544102primeval
proemial1249182proemial
repeal84718282_repeal
reseal64819642_reseal
reveal94115052_reveal
areal55928733ar__eal
bemean10410683_bemean
bonemeal1245163bonemeal
bromal10313653brom_al
brumal1049503brum_al
cereal8315833_cereal
cornmeal1245853cornmeal
credal9311673cre_dal
creedal1037093creedal
creel75121483cre_e_l
creme94319323creme__
cremes104517993creme_s
crenel84213063crene_l
crestal9312133crestal
crewel114310473crewe_l
demean9510563_demean
dermal93614343derm_al
ephemeral1653883ephemeral
freeman1237343freeman
gremials1136133gremials
haemal113811643haem_al
hemal104419803_hem_al
hiemal11339503hiem_al
irreal657833ir_real
meal65643173___meal
oatmeal944973oatmeal
ordeal779253or_deal
paleal84716673p_aleal
parental10310943parental
peal68648103p___eal
pedal86022503p_e_dal
peel65535613p_e_e_l
penal75228373p_e_nal
penial84120893p_enial
perea75026443p_erea_
perigeal1147543perigeal
perineal1049183perineal
permeable1556813permeable
permeably1864883permeably
permeant12310913permeant
permease1246503permease
permeate12311613permeate
permed115217343perme_d
permian112612283permian
peroneal1049163peroneal
peroral9314793peroral
perusal939193perusal
petal76526893p_e_tal
phaseal1245673phaseal
piecemeal1552083piecemeal
pineal84817683p_ineal
pleonal937243pleonal
pleural956673pleural
plexal1536833ple_xal
pommel12277453pomme_l
praedial1178763praedial
preaxial1746973preaxial
prebasal1244723prebasal
prebend12319443prebend
prebendal1444003prebendal
prebill1138803prebill
preboil1148953preboil
precaval1544723precaval
precede1239643precede
precent113520263precent
precept133112513precept
precess11310863precess
preclean1245893preclean
preclear1245423preclear
precool1139013precool
predeath1447003predeath
predella1145383predella
pree67044733pre_e__
preed85128113pre_e_d
preemie11310563preemie
preempt1337723preempt
preen75925053pre_e_n
preens85020113pre_ens
prees75937173pre_e_s
prefab1336243pre_fab
prefect141011073prefect
prefer113813203prefe_r
prefers123713333prefers
prefeudal1542383prefeudal
prefixal2044543prefixal
preheats1339413preheats
prelaw1139103pre_law
prelect111013833prelect
preload1049813preload
premade12311443premade
premedic1546293premedic
premedical1745313premedical
premie103617993prem_ie
premier113515633premier
premiere12249233premiere
premiers122911653premiers
premies113823063premies
premise113818553premise
premiss113513813premiss
premium13310363premium
premix173710333prem_ix
premixt183510663premixt
premolar1246633premolar
premold1247863premold
premolt11312073premolt
premune1138933premune
prenatal1048373prenatal
prepay13310313pre_pay
prepill1147583prepill
preplan1149953preplan
prepupal1164263prepupal
prequel1836343prequel
prerectal1345693prerectal
presa74319043pre_sa_
presale9416353pre_sale
prese75228383prese__
presells1058273presells
present94022733present
preset84430983prese_t
presets94216423presets
presoak1348453presoak
pretax152310193pre_tax
preteen939873preteen
pretells1047323pretells
pretend104011013pretend
preterm11310153preterm
pretest9517633pretest
pretext1639663pretext
pretreat10311923pretreat
pretrial10511983pretrial
pretzel1835143pretzel
prevail1238243prevail
prevent124016553prevent
preverb14317063preverb
preverbal1643883preverbal
prewar114712573pre_war
prewrap14104973prewrap
prexes154915943prexe_s
preyed125313193preye_d
preyer114413733preye_r
preyers124412363preyers
prezes173614693preze_s
prima95019343prim_a_
primas104418103prim_as
primatal1247133primatal
prime96525603prime__
primed115118913prime_d
primely1457713primely
primer105118683prime_r
primero11368923primero
primers114215673primers
primes104225263prime_s
primula1145713primula
propel103714063prope_l
protea82214763protea_
protean92412193protean
proteas92015123proteas
pummel12278043pumme_l
pyemia1337553pyemia_
pyemias1436803pyemias
pygmean1542223pygmean
pyrexial20234963pyrexial
ramal74622243_ram_al
real45750293_r__eal
rebel73421293_rebe_l
recoal84117973_recoal
rectal84418133_rectal
redear73515173_redear
redial74923113_redial
reel45240533_re_e_l
refeel93913243_refeel
refel84920813_refe_l
refell94214443_refell
regal65023793_re_gal
regear73512743_regear
regnal74812933_regnal
rehear93713223_rehear
reheat94423943_reheat
reheel93610823_reheel
remail85017123_remail
reman75730153_rem_an
remap95418103_rem_ap
remedial1147543_remedial
remedy1237863_remedy
remeet86325473_remeet
remelt85123123_remelt
remend95216553_remend
remet74843723_reme_t
remex146315793_reme_x
removal1236733_removal
renal55929503_re_nal
renewal1038703_renewal
rental63922023_rental
repeals94014523_repeals
repeat85127213_repeat
repel74921403_repe_l
reread71715433_reread
reseals73917663_reseals
reseat64131493_reseat
reseau64216213_reseau
resell64215203_resell
reteam83214533_reteam
retear63115483_retear
retell63813643_retell
retial64724993_retial
retral64419743_retral
reveals103812723_reveals
revel84423163_reve_l
rewear93011993_rewear
tramel84113713trame_l
tramell9398703tramell
trumeau944163trumeau
ureal56722683ur__eal
uredial82910483uredial
uremia82910893uremia_
uremias9249503uremias
ureteral856233ureteral
vermeil1285223vermeil

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.1401276364.3
2DLD Change Limit1340272407.34318252.3
3Display Results2402400.0803000.0
 (SQL Overall)1786912407.56323627.0
 
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.