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

147 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
fractions144910(None) 
factions133013061f_actions
fraction1359481fraction_
fractious1456141fractious
frictions1448031frictions
tractions11511621tractions
actions94218512__actions
coactions1349742coactions
erections112515212erections
exactions1838922exactions
faction122613332f_action_
factious13239242f_actious
fictions132410742f_ictions
flections14239212flections
fractional1547122fractional
fractioned1644612fractioned
friction1347912friction_
fruitions12106112fruitions
functions1437742functions
furcations1547532furcations
inactions1139322inactions
infractions1646962infractions
orations81515802ora_tions
pactions122613502_pactions
proactions1449342proactions
rations74123432_ra_tions
reactions11711712reactions
refractions16127722refractions
ructions102811682_ructions
tactions102912422_tactions
traction10412682traction_
abreactions1544193abreactions
actinons10389453__actinons
actins86321103__acti_ns
action84719683__action_
adaptions1245223adaptions
aerations9317903aera_tions
affections1845893affections
alations82518893ala_tions
attractions1376403attractions
auctions104012143_auctions
bastions10411693_bastions
captions123813223_captions
cations94524143_ca_tions
cautions103313183_cautions
coaction12310773coaction_
cratons94316033cra_t_ons
creations112614543creations
detractions14118273detractions
dictions111812673_dictions
diffractions2153273diffractions
directions1379633directions
durations10311463dura_tions
eductions1268773eductions
ejections18249963ejections
elations83719123ela_tions
elections112414973elections
enations83316903ena_tions
erasions8310983era_sions
erection102115513erection_
eruptions1146763eruptions
evections142510693evections
evictions14228623evictions
exaction1738953exaction_
extractions2077743extractions
facetious1464443f_acetious
factional1478763f_actional
factoids1446243f_actoids
factors12912123f_act_ors
falchions1743913falchions
fanions103713073f_a_nions
fashions1437243f_ashions
fetations12511383fetations
fiction122010733f_iction_
fixations1936353fixations
flacons1238053flac__ons
flatirons1244483fla_tirons
flection13239563flection_
formations1538203formations
fractals1346133fract_als
fracti1139963fracti___
fractionate1654263fractionate
fractionates1754163fractionates
fractioning1744333fractioning
fractiously1985533fractiously
fractures14147233fractures
fracturs13146313fract_urs
fractus12146593fract__us
frictional1546243frictional
frontons1136503front_ons
fructuous1442393fructuous
fruition11106103fruition_
function1337843function_
furcation1448353furcation_
gracious1138593grac_ious
gradations1286863gradations
gratins84119183gra_ti_ns
gravitons1343963gravitons
gyrations1336923gyra_tions
impactions1645413impactions
inaction1039623inaction_
infarctions1645023infarctions
infraction1557453infraction_
junctions1835943junctions
kations114013663_ka_tions
lections102413843_lections
locations112512743locations
nations74720563_na_tions
nonactions1248373nonactions
olfactions1563873olfactions
oration71617713ora_tion_
ovations11149263ova_tions
overactions1648213overactions
paction112713963_paction_
placations1438583placations
practices1557993practices
practises1349623practises
proaction13410103proaction_
raccoons1265453_raccoons
racons84319343_rac__ons
racoons93912433_rac_oons
rampions12248023_rampions
ration64226013_ra_tion_
ratios64922673_ra_tio_s
ratoons73815473_ra_toons
rattons73815323_ra_ttons
rattoons8327513_rattoons
reaction10612603reaction_
redactions1359133redactions
refraction15137903refraction_
retractions13910353retractions
ruction93611613_ruction_
ructious10277083_ructious
sanctions1138873sanctions
sections102714703_sections
stations82415223sta_tions
stictions1148353stictions
strictions1249143strictions
suctions103012903_suctions
taction93213023_taction_
tractional1248043tractional
tractors10312563tract_ors
traditions1147193traditions
trajections2044513trajections
unctions1039733_unctions
vacations141910553_vacations
vocations141911423vocations

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411477.17020731.0
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.40624127.9
 
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.