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

149 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
protractions164664(None) 
protraction1547211protraction_
proactions1449342pro__actions
prorations12314462pro_ra_tions
prostrations1449772prostra_tions
protections15510702prot_ections
protracting1646932protracti_ng
protractors1546622protract_ors
retractions13910352_retractions
abstractions1645793abstractions
attractions1376403_attractions
contractions16410403contractions
detractions14118273_detractions
distractions1548763distractions
extractions2077743_extractions
perorations13314063pero_ra_tions
photoreactions21113563photoreactions
potations111615073p_ot_a_tions
proaction13410103pro__action_
probations14311083pro_ba_tions
procreations1647273procreations
procurations1647403procura_tions
productions1647533pro_ductions
projections2258473pro_jections
prolactins1447153pro_lacti_ns
pronations12314033pro_na_tions
proration11415983pro_ra_tion_
prostration13410793prostra_tion_
protection14511473prot_ection_
protonations1449073protonations
protractile1554103protracti_le
protractive1855633protracti_ve
protractor1446263protract_o_r
protracts1347023protract___s
protrusions1354143protr_usions
provocations1956873provocations
refractions16127723_refractions
retraction121310533_retraction_
retroactions1447073_retroactions
rotations91613843_rot_a_tions
subtractions1645373subtractions
tractions11511623___tractions
abstraction1545884abstraction_
adorations11310244ado_ra_tions
arbitrations1445774arbitra_tions
attraction1276954_attraction_
castrations13410074castra_tions
coactions1349744_co__actions
compactions1946544_compactions
contraction15411244contraction_
contraptions1647644contraptions
corotations1349774corot_a_tions
corrections1548874_corrections
destructions1547264destructions
detraction13138584_detraction_
diffractions2153274diffractions
distraction1449124distraction_
dotations101411634_dot_a_tions
erotizations21411004erotizations
extraction1967984_extraction_
filtrations1445624filtra_tions
flotations1366874flot_a_tions
fractions1449104___fractions
frustrations1544534frustra_tions
infractions1646964_infractions
instructions14137824instructions
interactions14410464interactions
lustrations1147624lustra_tions
nitrations10312034_nitra_tions
nonactions1248374_no_nactions
notations91512974_not_a_tions
obstructions16155524obstructions
olfactions1563874__olfactions
orations81515804__o_ra_tions
overactions1648214_overactions
pactions122613504p____actions
peltations12311554pelt_a_tions
penetrations1448854penetra_tions
perforations1747874perfora_tions
peroration12316004pero_ra_tion_
perpetrations1746374perpetra_tions
petrifactions2083564p_etrifactions
phonations1538314pho_na_tions
photoreaction20134174photoreaction_
portions10514414p_o_r__tions
portraitists1452854portraitists
potation101716784p_ot_a_tion_
precautions1546554pr_ecautions
predations13812154pr_eda_tions
predications17411184predications
predictions1649654pr_edictions
prelections151210474pr_elections
preparations1648314preparations
pretrains11410144pretra__i_ns
privations15310104pr_iva_tions
probation13412184pro_ba_tion_
proclamations1952694proclamations
procreation1547954procreation_
procuration1548294procura_tion_
production1547894pro_duction_
profanations17175254profanations
progressions1555554progressions
prohibitions1953834prohibitions
projection2158764pro_jection_
prolactin1347774pro_lacti_n_
promotions1448784pro__motions
pronation11415704pro_na_tion_
propagations1745554propagations
propitiations1756204propitia_tions
proportions1548464pro_portions
propositions16108314propositions
propraetors1554184propraet_ors
prorating12314284pro_ra_ti_ng
prorogations1556724prorogations
proscriptions19114164proscriptions
prosecutions1645614prosecutions
prostitutions1554254prostitutions
prostrating1449394prostra_ti_ng
protamins131410774prot_a_mi_ns
protecting151910214prot_ecti_ng
protectionism1984944prot_ectionism
protectionist17116684prot_ectionist
protectors142010144prot_ect_ors
protestations1555814protestations
protonation13510434protonation_
protract12510604protract____
protracted1545764protract__ed
protreptics1753474protrepti_cs
protrusion1254354protr_usion_
provocation1847354provocation_
putrefactions2052274p_utrefactions
quotations19146284quot_a_tions
reactions11711714_r__eactions
redactions1359134_r_edactions
refraction15137904_refraction_
restrictions1449294restrictions
retracting13311934_retracti_ng
retractors12158584_retract_ors
retroaction1347364_retroaction_
rogations101510824_ro_ga_tions
rotation81615454_rot_a_tion_
strictions1249144__strictions
subtraction1545624subtraction_
tactions102912424___t_actions
titrations1039174_titra_tions
traction10412684___traction_
transactions1445884transactions
triturations1245684tritura_tions
urtications1348044ur_tications

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 Filter1786911247900.406440125.6
2DLD Change Limit1247901498.14015330.5
3Display Results1491490.0931602.2
 (SQL Overall)1786911498.63920684.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.