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

421 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
perlite931731(None) 
pearlite1039441pearlite
pelite84323001pe_lite
penlite9313241penlite
perlites10316351perlites
aerolite8315052aerolite
berline93716852berline
cerite84724872cer_ite
elite56230182_e_lite
ferlie92814052ferli_e
ferrite103312752ferrite
kernite1159472kernite
marlite92917072marlite
partite9317132partite
pealike131211272pealike
pearlites1138232pearlites
peglike14136772peglike
pelites93821992pe_lites
penlites10312272penlites
perdie94718512perdi_e
periti8319952per_iti
perlitic12310582perlitic
permit10321682permit_
permits11314002permits
permute1138792permute
petite84320652pe_tite
polite83625072p_olite
prelate9519692prelate
prelife1279942prelife
purline93516532purline
pyrite11913312pyr_ite
tergite8311002tergite
termite9313892termite
verite94323442ver_ite
yperite1249892yper_ite
zeolite1638902zeolite
aerate64830553aer_ate
aerie54634603aer_i_e
aerolites9312583aerolites
aerolith1149833aerolith
airlike11310333airlike
airline7315033airline
apelike13310533ape_like
aplite8316393_aplite
arenite71017713arenite
barite84224813bar_ite
bearlike14156793bearlike
bedlike14369533bedlike
beelike13379783beelike
beeline93314723beeline
belie75630383be_li_e
belike124616283be_like
belive115415303be_live
berate84729023ber_ate
berime105317333ber_ime
berlin83116373berli_n
berlines102315453berlines
berlins93216013berlins
beryline1337083beryline
beslime1146833beslime
blite76225353__blite
bornite9311183bornite
burkite1337003burkite
carline93923613carline
cerate84829463cer_ate
cerise84822043cer_ise
cerites94823433cer_ites
cerusite1047763cerusite
cervine122610803cervine
cordite10315263cordite
curite85222943cur_ite
dealate83617843dealate
decline103716613decline
deerlike1335723deerlike
deflate113613943deflate
delate73827753de_late
delete73620703de_lete
delime9314043de_lime
deplete103010413deplete
derate74531233der_ate
deride84420033der_ide
derive103817043der_ive
despite10410123despite
eellike1138233eellike
eerie55228533eer_i_e
egalite8311563egalite
elate55335883_e_late
elide64922643_e_lide
elites66027123_e_lites
elute54822573_e_lute
endite73817593_endite
eolith93013903_eolith
epilate9314283epilate
eremite9312833_eremite
ergate7315143_ergate
ermine8416923_ermine
erudite838483_erudite
evite85317683_e_vite
excite15310883_excite
feline94820143fe_line
fellate10313433fellate
felsite1039083felsite
feriae95618603fer_iae
ferine96422583fer_ine
ferity122813343fer_ity
ferlies103216693ferlies
fermate122813003fermate
fernlike1535243fernlike
ferrate103014043ferrate
ferrites112312833ferrites
fertile10311733fertile
flite85424963__flite
gelate73421253ge_late
gemlike14206813gemlike
germlike1535093germlike
girlie73711463girli_e
halite93624233_halite
haplite12310703haplite
hellkite1544933hellkite
hemline12311073hemline
henlike1448693henlike
herblike1735883herblike
herdlike1636113herdlike
hermit11519443hermit_
hermits12312143hermits
herniae1039043herniae
herniate1148113herniate
heroine103517483heroine
heroize193210963heroize
hessite1038993hessite
hoplite12311073hoplite
hyalite13229473hyalite
illite63414923_illite
iolite63221983_iolite
jetlike18276763jetlike
kernites1269113kernites
leglike12136843leglike
lenite6719983le_nite
leucite937753leucite
lite47054543___lite
marline93320953marline
marlites103415263marlites
marmite112413993marmite
mealie82519813meali_e
melilite10410573melilite
merit7339183mer_it_
merited10313853mer_ited
merits8320873mer_its
merle75824373merl__e
merlin83916683merli_n
merlins93015813merlins
merlot83217603merlot_
merlots92710123merlots
mullite9313013mullite
neglige934873neglige
nellie63614813nelli_e
neolith1068783neolith
nervate1039523nervate
nervine102510623nervine
netlike11308913netlike
norite63221133nor_ite
oarlike113411193oarlike
oolite63319603_oolite
operate9615733oper_ate
overbite13312083overbite
overlate11716283overlate
overlie102615013overli_e
overlit102714743overlit_
overlive142211293overlive
palate84226783p_alate
palliate10311893palliate
parakite14410423parakite
parasite10314843parasite
pardie96021443pardi_e
pardine103616723pardine
parity114719873par_ity
parklike1337493parklike
parlante1039693parlante
parle75836163parl__e
parling103823763parling
partita9310863partita
parvise124211693parvise
peaklike13115373peaklike
pealing104123203pealing
pearlier1037323pearlier
pearling11912013pearling
pearlitic1345523pearlitic
pearlized2145553pearlized
pectate112214693pectate
pectize20259913pectize
peculate122414663peculate
pedate93117763pe_date
peeling102919873peeling
peerie83617893peeri_e
peewit111110903peewit_
peewits12105873peewits
peise75825773pe__ise
pelage9515363pe_lage
pele65539553pe_l__e
pelisse967063pe_lisse
pelitic111814653pe_litic
pellet83326553pellet_
pelleted1138193pelleted
pellets94014783pellets
pellicle1245043pellicle
pelmet103419243pe_lmet
pelota8612833pe_lota
pelt67651083pe_l_t_
peltate92013773peltate
pelted94617753pe_l_ted
pelter83321623pe_l_ter
pelts76128813pe_l_ts
pemoline12310273pemoline
penalise101013763penalise
penality13310713penality
penalize19912753penalize
penile82219603pe_nile
pennate93314033pennate
pennine93712953pennine
pensile92713543pensile
pensive122610393pensive
pepsine11310603pepsine
peptide122910683peptide
peptize20279483peptize
percale11314093percale
percaline13410953percaline
perceive1546973perceive
percolate13411153percolate
perdue93912633per_due
perdure10379623perdure
pere66450263per___e
pereia85217983perei_a
pereion9312053pereion
perfidy1635263perfidy
perfoliate1555433perfoliate
perfume1446503perfume
perfuse1247663perfuse
peri65636973per_i__
perigee101113383perigee
peril75425953per_i_l
periled10316313periled
periling11316863periling
perilla9311223perilla
perilled11410103perilled
perils84121853per_ils
perilune1046973perilune
perinea9313033per_inea
period9314983per_iod
peripter1278753peripter
perique1837523perique
peris75537073per_i_s
perish114619063per_ish
peritus9311803per_itus
perjure16327963perjure
perkier133813123perkier
perkily1637803perkily
perking143716463perking
perkish16258823perkish
permeate12311613permeate
permian112612283permian
perming123416093perming
permitted1446643permitted
permittee1346683permittee
permitter1345963permitter
permuted1336703permuted
permutes1238713permutes
pernio8513143perni_o
perorate10417923perorate
peroxide1848173peroxide
perries93226603perries
perse75429523per__se
persist9315853persist
persisted1247133persisted
persister1146833persister
persists1049183persists
perspire1246663perspire
pert66759323per__t_
perter84422283per__ter
peruke123210393per_uke
peruse84016843per_use
pervade1337023pervade
petaline10314883petaline
petit74332653pe_tit_
petites93820203pe_tites
pewit104622793pe_wit_
pewits112810683pe_wits
peyote1139853pe_yote
phyllite1645743phyllite
picrite111911313picrite
piglike14157313piglike
pinite8321243p_inite
pirate82322883pir_ate
pisolite10310373pisolite
plate74635113p__late
plie65127393p__li_e
podite93315353p_odite
podlike14108553podlike
poetlike1436733poetlike
police102918563p_olice
politer92417073p_oliter
polity113015863p_olity
pollute937383pollute
poplitei1245483poplitei
porcine11312843porcine
potlike13910123potlike
potline91015233potline
praise84419413p_raise
praline93019743praline
prate75135983p_r_ate
precipe133012123precipe
precise113518173precise
precited133013813precited
predate10616893predate
predive13511083predive
prefile123413183prefile
prefire124012813prefire
prelates10418573prelates
prelim10311423preli_m
prelims1139823prelims
prelives13310383prelives
prelude1038013prelude
premie103617993premi_e
premise113818553premise
preside10715613preside
preslice1258623preslice
preunite1039573preunite
previse123713793previse
prewire124311133prewire
price93725413p_r_ice
pride84724733p_r_ide
prime96525603p_r_ime
prise74632613p_r_ise
prize164718943p_r_ize
prolate9419793prolate
proline92321593proline
psephite1543843psephite
puerile9310093puer_ile
puerility1445993puerility
purine85321893pur_ine
purity114114913pur_ity
purlieu938143purlieu
purlin83615863purli_n
purlines103514053purlines
purling103620293purling
purlins93415423purlins
puslike1347563puslike
pyrites12812203pyr_ites
pyrolize2248133pyrolize
realise73021813realise
reality10313573reality
realize162717083realize
recite83625113re_cite
recline94020493recline
redline84218833redline
reflate103516263reflate
relate64033633re_late
reline65434353re_line
relit55340683re_lit_
relive95120783re_live
replate93420053replate
replete92912983replete
requite162012483requite
reraise7316313reraise
rerise64325633rer_ise
reroute7313963reroute
resite64128453re_site
reslate73520593reslate
respite9513033respite
reunite7312713reunite
rewrite10311143rewrite
rite45849453__r_ite
ruralite848963ruralite
serflike1536273serflike
seriate73722473seriate
serine65432673ser_ine
serrate73017543serrate
service1239083service
servile10310643servile
setline7313923setline
sparlike1437673sparlike
spearlike1544143spearlike
spermine12311433spermine
sperrylite1552853sperrylite
spherulite1553283spherulite
sprite84421773spr_ite
stellite839533stellite
sternite8310543sternite
stylite10219613stylite
superelite1249083superelite
superlie10312123superli_e
tealike111111083tealike
tectite9310583tectite
tektite1136883tektite
terete6319333ter_ete
tergites9310543tergites
termites10313693termites
ternate7415483ternate
terrine72517573terrine
territ63421373territ_
territs72714503territs
thermite1339033thermite
tillite7313563tillite
trite54730033_tr_ite
turgite837973turgite
uralite71714103uralite
velate93720143ve_late
velites103417303ve_lites
verbile1249863verbile
verditer1236223verditer
verites103822263ver_ites
verity123714853ver_ity
versine102515173versine
verste94515633ver_ste
warlike142410473warlike
weblike1635923weblike
website1235323website
wellie92814913welli_e
wellsite1145133wellsite
write85522833_wr_ite
yperites13310153yper_ites
zeolites1738383zeolites

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 Limit1340274217.01619103.1
3Display Results4214210.1562698.7
 (SQL Overall)1786914217.31224438.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.