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 “perfections” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

284 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
perfections184814(None) 
perfection1748361perfection_
defections161510202de_fections
erections112515212_er_ections
imperfections2254002imperfections
perceptions1798192perceptions
perfecting1847512perfecti_ng
perfectionism2253982perfectionism
perfectionist2055332perfectionist
perfectives2145472perfectives
perfectos16106072perfect_o_s
permeations1549882permeations
persecutions1654792persecutions
prelections151210472prelections
refections151811642re_fections
affections1845893_affections
confections18411393confections
corrections1548863corrections
defecations1779003de_fecations
defection151610643de_fection_
deflections17187323deflections
dejections20168353de_jections
detections131410043de_tections
directions1379643dir_ections
ejections18249963_e_jections
elections112414973_e_lections
erection102115513_er_ection_
evections142510693_e_vections
exsections1947633_exsections
imperfection2154043imperfection_
infections15510233_infections
perception1688613perception_
perditions1348873per_ditions
pereions10310853per_e__ions
perfectas16135073perfect__as
perfecters1745433perfect_ers
perfectible2053433perfectible
perfectionisms2363293perfectionisms
perfectionists2164013perfectionists
perfective2047193perfecti_ve
perfectness1853503perfectness
perfecto15105743perfect_o__
perfects15107353perfect___s
perforations1747873perforations
perfusions1595333perf_usions
permeation14410563permeation_
perorations13314063perorations
persecution1564783persecution_
perversions1645413perversions
petrifactions2083563petrifactions
predictions1649653predictions
prelection141511293prelection_
preventions1648533preventions
proactions1449343p_roactions
projections2258473projections
protections15510703protections
reelections13167943reelections
refection141512283re_fection_
reflections16178553reflections
refractions16127723refractions
reinfections1745323reinfections
rejections191510103re_jections
resections121513033re_sections
selections12310873se_lections
surjections2075283surjections
abjections2145674_abjections
abreactions1544194abreactions
advections1645554_advections
aerations9317904aer__ations
affection1745894_affection_
apperceptions1893034apperceptions
benefactions1952694benefactions
bijections21134934_bijections
bilections14136504_bilections
bisections14136734_bisections
bolections14137294_bolections
collections1547934collections
confection17411184confection_
connections15410704connections
convections18411494convections
correction1448814correction_
creations112614544_cr_eations
deceptions1547864de_ceptions
decoctions1547144de_coctions
deductions1467134de_ductions
defecation1679804de_fecation_
defecting162510224de_fecti_ng
defectives1945684de_fectives
defectors15237884de_fect_ors
deflations1439714de_flations
deflection16147734deflection_
deifications18410654deifications
dejection19178664de_jection_
deletions102610934de_le_tions
depictions1546894de_pictions
depletions1355744deple_tions
deprecations1748564deprecations
derelictions1544334derelictions
derivations15611494derivations
derogations1349394derogations
desertions1139884de_sertions
detection121310414de_tection_
detentions11148804de_tentions
detractions14118274detractions
direction1289784dir_ection_
dissections14198264dissections
eductions1268774_e_ductions
effecting1845584_effecti_ng
effectives21134564_effectives
effectors1755034_effect_ors
egestions1046704_e_gestions
ejection172510044_e_jection_
election102015354_e_lection_
electrons112411754_e_lectrons
erecting112415064_er_ecti_ng
erectors103514264_er_ect_ors
eruditions1146104_eruditions
eruptions1146764_er_uptions
evection131910834_e_vection_
evictions14228624_e_victions
exactions1838924_e_xactions
exceptions2146864_exceptions
executions1946394_e_xecutions
exertions1639764_e_xertions
exsection1847494_exsection_
exsertions1746744_exsertions
factions133013064___factions
fictions132410744___fictions
flections14239214__flections
fractions1449104_fr_actions
frictions1448034_fr_ictions
genuflections1951514genuflections
herniations1447404herniations
hyperfunctions2762664hyperfunctions
imperfectives2562044imperfectives
infection14410474_infection_
infectious1545604_infectious
inflections1646994inflections
infractions1646964infractions
injections1948664_injections
inspections1546424inspections
interjections2277994interjections
intersections1598964intersections
ivermectins1852864ivermecti_ns
lections102413844___lections
metafictions1952654metafictions
midsections1644404midsections
nervations1359484ner_vations
nonfictions1645934nonfictions
objections2145634_objections
olfactions1563874_olfactions
operations12312954oper__ations
overactions1648214over_actions
overreactions1854724overreactions
pactions122613504p___actions
partitions1248324par_titions
pectins112315234p___ecti_ns
peculations15310284peculations
peltations12311554pe_ltations
percentiles1546204percentiles
perceptional1854904perceptional
percolations1648054percolations
percussions1544874percussions
perdition1249014per_dition_
peregrins1246964per_egri_ns
pereion9312054per_e__ion_
perennations1447254perennations
pereons92815004per_e___ons
perfect141010834perfect____
perfecta15115204perfect___a
perfected1736644perfect__ed
perfecter1646044perfect__er
perfectest1744814perfect_est
perfectionistic2471904perfectionistic
perfectively2554834perfectively
perfectiveness2455344perfectiveness
perfectivity2563844perfectivity
perfectly1944114perfect__ly
perfidious1653674perf_idious
perforation1649004perforation_
perfusion14105884perf_usion_
permeating1539924permeati_ng
permeators1447404permeat_ors
permissions1545334permissions
permutations1646504permutations
pernicious1445504pernic_ious
peroration12316004peroration_
perpetrations1746374perpetrations
perpetuations1754984perpetuations
persecuting1643834persecuti_ng
persecutors1553154persecutors
personations1448394personations
perspectives2153514perspectives
persuasions1383914persuasions
pervasions1545664per_vasions
perversion1545854perversion_
perverting1646624perverti_ng
petitions11511084pe__titions
petrifaction1953724petrifaction_
petrifications2148024petrifications
plectrons13258074p__lectrons
portions10514414por___tions
precautions1546554precautions
precessions1548554precessions
precious12310594p_r_ec_ious
precisions1449374p_r_ecisions
predations13812154p_redations
predications17411184predications
prediction15410304prediction_
predilections1853564predilections
preelection15136484preelection_
preemptions17134854preemptions
prefects1598134prefect___s
prefectures1844304prefectures
prefixions2243874pref_ixions
prehensions1645944prehensions
prelecting15310164prelecti_ng
prelectors1447874prelect_ors
prenotions1248294p_renotions
preoptions1447644p_reoptions
preportions1548264preportions
preselections17144444preselections
pretensions1347084pretensions
pretentious13125594pretentious
preunions1146484p_r_eunions
prevention1549174prevention_
privations15310104p_rivations
proaction13410104p_roaction_
probations14311084p_robations
productions1647534productions
professions1646634professions
projection2158764projection_
promotions1448784p_romotions
pronations12314034p_ronations
prorations12314464p_rorations
prosecutions1645614prosecutions
protection14511474protection_
purgations1346744pur_gations
purifications2047464purifications
putrefactions2052274putrefactions
rarefactions1752414rarefactions
reactions11711714__reactions
receptions1449744re_ceptions
recreations13412254recreations
redactions1359134re_dactions
redirections1546174redirections
reductions1359584re_ductions
reelection12198634reelection_
refecting152413354re_fecti_ng
reflations13311234re_flations
reflection15168994reflection_
refraction15137904refraction_
reifications17411824reifications
reinfection1645444reinfection_
reinjections2144404reinjections
rejection181710254re_jection_
relictions12310024re_lictions
repletions1247474reple_tions
resection111613274re_section_
resurrections1553464resurrections
retentions101611114re_tentions
retractions13910354retractions
retroactions1447074retroactions
retroflections1953874retroflections
ructions102811684__r_uctions
secretions12117854secre_tions
sections102714704___sections
seductions1366874se_ductions
selection11311274se_lection_
seriations10316684ser_iations
serrations10313094ser_rations
strictions1249144str_ictions
subjections2296354subjections
subsections1597104subsections
superfetations1975064superfetations
superinfections2263414superinfections
superventions18125784superventions
surjection1974904surjection_
tractions11511624_tr_actions
trajections2044514trajections
trisections1345644trisections
venesections1752934venesections
verifications21159974verifications
vernations13310334ver_nations

Search took 10 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 Filter1786911488190.466383457.1
2DLD Change Limit1488192848.75317002.1
3Display Results2842840.1531856.2
 (SQL Overall)1786912849.37219066.5
 
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.