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

293 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
predries11271438(None) 
predried12309571predried
redries83721711_redries
drearies92313412drearies
peeries93623022p_eeries
perries93226602p_erries
poetries10315582poetries
prairies10411452prairies
predates11615812predates
predrill1145932predrill
predrills1244472predrills
preemies12512192preemies
prefires134313282prefires
premies113823062pre_mies
preppies1149692preppies
preprices1569262preprices
pretrims1238982pretrims
pretties10615132pretties
prewires133811012prewires
prexies163415002pre_xies
priories10312452priories
pruderies1247872pruderies
redried93714902_redried
redrives122610392_redrives
refries104419732_refries
retries74129072_retries
aeries64737783_ae_ries
aperies9423203ape_ries
armories10313653armories
arteries8321503arteries
bawdries14136843bawdries
beedies10314203beed_ies
berries94423553_berries
bredes94818473bred__es
breweries1447583breweries
cherries131812993cherries
credits1039973cred_its
creepies1239613creepies
dearies83526273_dearies
decries103319813_decries
derries83124623_derries
drearier9297923drearier
dreariest10229123dreariest
dredges10379353dred_ges
dries64733673___dries
eddies83313163__eddies
emeries91620023eme_ries
ephedrines1643433ephedrines
ephedrins1544153ephedrins
eyries93816813__eyries
faeries104118993fae_ries
ferries103521083_ferries
freebies1337873freebies
frenzies2037713frenzies
freres94716173fre_r_es
friaries11310083friaries
greenies9312673greenies
gremmies1355993gremmies
henries102718283_henries
herries104025083_herries
jerries143817513_jerries
kerries113317913_kerries
neddies92710703_neddies
orderlies1045453orderlies
orreries8310123orreries
overdries13310883overdries
paddies113715723p_addies
padres95016983p_adr_es
pandies104224503pand_ies
panfries13149203panfries
pantries101817393pantries
paries84742513p__aries
parodies11313693parod_ies
parries93925843p_arries
pastries101517423pastries
peavies122213403p_eavies
peddles112913703p_eddles
pedes85327293p_ed__es
pedlaries12108793p_edlaries
pedleries1298783p_edleries
pedros9312183p_edr_os
peerie83617893p_eerie_
peltries10313023peltries
pennies94218813p_ennies
penuries10311663penuries
peonies93620153p_eonies
perdie94718513perd_ie_
perdues103511333perd_ues
perdures11289683perdures
peregrines1346513peregrines
peregrins1246963peregrins
peres76246643p_e_r_es
perils84121853p_e_rils
peris75537073p_e_ri_s
perjuries1846493perjuries
perses85428063p_e_rses
phratries1447583phratries
phrensies1445743phrensies
pierces113411193pie_rces
pieties9419223pie_ties
pineries102419083pineries
pledgees12376283pledgees
pledges113811583pled_ges
plenaries11410383plenaries
plenties10314693plenties
poesies93217403poe_sies
poperies12316793poperies
prairie938333prairie_
preaches153214893preaches
preadmits1444923preadmits
prearmed1397993prearmed
prearms11369173prear_ms
prebakes1639013prebakes
prebids12399883pre_bids
preboils1267293preboils
precedes13310713precedes
precipes143212213precipes
precis103416703pre_ci_s
precise113518173pre_cise
precises123218333precises
precodes13711573precodes
precrisis1346453precrisis
precures12312903precures
predate10616893predate_
predated12513273predated
predawns1444363predawns
predefines1645433predefines
predial103815413pred_ial
predict12315323pred_ict
predicts1339613predicts
predigest1357633predigest
predive13511083pred_ive
predraft1447593predraft
predrilled1443453predrilled
predry1237873predr__y
predrying1645343predrying
predusks1543423predusks
preedits1168763preedits
preemie11310563preemie_
prees75937173pre___es
prefaces15311063prefaces
prefades1439533prefades
prefiles133113443prefiles
prefire124012813prefire_
prefired144310753prefired
prefixes20389233prefixes
pregames1339003pregames
preguides1344863preguides
prelacies13310053prelacies
prelates10418573prelates
prelims1139823pre_lims
prelives13310383prelives
preludes1137833preludes
premie103617993pre_mie_
premier113515633pre_mier
premiers122911653pre_miers
premise113818553pre_mise
premises123018273premises
premiss113513813pre_miss
premixes193110083premixes
prenames12311643prenames
prentices131111903prentices
preorder1136463preorder
preorders1235403preorders
prepares122014163prepares
prepaves15189193prepaves
preppie1058093preppie_
preppier1156643preppier
preppiest1236983preppiest
prepreg12165963prepr_eg
prepregs13144763prepregs
prepress12137983prepress
preprice1488873preprice
prepriced1676643prepriced
preprint12314183preprint
preprints1347473preprints
prepubes1436053prepubes
prepuces1438583prepuces
prerinse1038633pre_rinse
prerinses1138813pre_rinses
preriot9316413pre_riot
presages11312203presages
presales10315263presales
prescribes16106283prescribes
preserves14109073preserves
preships1539313preships
presides11414913presides
preslices1338213preslices
presses93523153pre_sses
prestiges12310593prestiges
presumes1239843presumes
pretapes122811533pretapes
preterites12411803preterites
preterits11410973preterits
pretrains11410143pretrains
pretrial10511983pretrial
pretrials1158143pretrials
pretrim11310783pretri_m
prettied1159253prettied
prettier1069043prettier
prettiest1199803prettiest
pretypes15337263pretypes
preunites1138933preunites
prevails1337663prevails
preview1536473pre_view
previews1634513pre_views
previse123713793pre_vise
previses133814283previses
prevues1239263pre_vues
prewire124311143prewire_
prewired14358473prewired
prewraps15114053prewraps
prexes154915953pre__xes
prezes173614693pre__zes
prides94324183prid__es
priedieu1153983pried_ieu
priedieus1242943pried_ieus
pries74339533p___ries
primaries13410833primaries
prissies101712003prissies
privies122414263pr_ivies
prodigies1346953prodigies
prodromes1446063prodromes
prodrugs1242483prodrugs
produces1347903produces
prossies101515233prossies
prosties101421193prosties
proxies163014933pr_oxies
prudes94215443prud__es
pterins9812993pte_rins
puggries12166383puggries
queries16315873que_ries
readies83324713_readies
reburies10311143_reburies
redates83423873_redates
reddles93315773_reddles
redefies12710163_redefies
redenies9615713_redenies
redes65139133_red__es
redeyes112910973_redeyes
redfins1139923_redfins
redias74523603_red_ias
redips93713843_red_ips
redlines93916083_redlines
redoes74623773_red_oes
redoxes15310883_redoxes
redraws11218473_redraws
redress82511873_redress
redrew10309513_redr_ew
redrill857893_redrill
redrills956083_redrills
redrive112410563_redrive
redriven12226153_redriven
reduces10513343_reduces
redyes104214093_red_yes
refires104820313_refires
reflies104418533_reflies
refried113513883_refried
rehires105016113_rehires
reifies104218283_reifies
relies65036423_re_lies
replies94521043_replies
reprices122913353_reprices
reprise92715043_reprise
reprises102615463_reprises
rerigs74014793_re_rigs
rerise64325633_re_rise
rerises73525883_re_rises
reties65436193_re_ties
retires74726213_retires
retried84419163_retried
retrims93612373_retrims
reveries112518513_reveries
rewires104717113_rewires
rewrites11311063_rewrites
ruderies9311333_ruderies
series64540973_se_ries
serries73925353_serries
sherries111812903sherries
skerries12168673skerries
sundries9312023sundries
tawdries12136083tawdries
teddies92711283_teddies
terries73425633_terries
theories11311593theories
treaties8316983treaties
treddles1036263treddles
trendies9312213trendies
updries10209083_updries
veeries102916893_veeries
wearies103020233_wearies
wedgies123910213_wedgies
wherries14179033wherries

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622937.45619603.3
3Display Results2932930.1232382.1
 (SQL Overall)1786912937.98222386.7
 
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.