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

140 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
selections1231087(None) 
elections112414971_elections
selection11311271selection_
bilections14136502bilections
bolections14137292bolections
defections161510202defections
deflections17187322deflections
dejections20168352dejections
deletions102610932dele_tions
detections131410042detections
ejections18249962_ejections
election102015352_election_
electrons112411752_electrons
erections112515212_erections
evections142510692_evections
flections14239212_flections
lections102413842__lections
prelections151210472prelections
reelections13167942reelections
refections151811642refections
reflections16178552reflections
rejections191510102rejections
relictions12310022relictions
resections121513032resections
sections102714702s__ections
seductions1366872seductions
selecting12310532selecti_ng
selectionist1458082selectionist
selectors1148962select_ors
abjections2145673abjections
advections1645553advections
affections1845893affections
bijections21134933bijections
bilection13156803bilection_
bisections14136733bisections
bolection13117673bolection_
collections1547933collections
deceptions1547863deceptions
decoctions1547143decoctions
deductions1467133deductions
defecations1779003defecations
defection151610643defection_
deflection16147733deflection_
dejection19178663dejection_
delations102616593del_ations
delectations1547453delectations
delegations1348033delegations
deletion92011973dele_tion_
depictions1546893depictions
depletions1355743deple_tions
desertions1139883desertions
detection121310413detection_
detentions11148803detentions
directions1379643directions
eductions1268773_eductions
egestions1046703_egestions
ejection172510043_ejection_
elations83719123_el_ations
electing112113783_electi_ng
electives1448933_electives
electors103013843_elect_ors
electron102611413_electron_
electros102811743_electro_s
elevations1338633_elevations
elocutions1245963_elocutions
elutions82513053_el_utions
erection102115513_erection_
evection131910833_evection_
evictions14228623_evictions
exactions1838923_exactions
executions1946393_executions
exertions1639763_exertions
exsections1947633exsections
fellations1338063fellations
flection13239563_flection_
gelations102513093gel_ations
infections15510233infections
inflections1646993inflections
injections1948663injections
lectins92515003__lecti_ns
lection92614863__lection_
nonelections1456393nonelections
objections2145633objections
peltations12311553peltations
perfections1848143perfections
plectrons13258073_plectrons
prelection141511293prelection_
preselections17144443preselections
reactions11711713re_actions
receptions1449743receptions
redactions1359133redactions
reductions1359583reductions
reelection12198633reelection_
refection141512283refection_
reflection15168993reflection_
rejection181710253rejection_
relations92418333rel_ations
relegations1248973relegations
reliction11310693reliction_
relocations13311143relocations
repletions1247473reple_tions
resection111613273resection_
retentions101611113retentions
saltations10310623saltations
salvations1338133salvations
sanctions1138873s_anctions
secessions1246463secessions
secretions12117853secretions
section92515663s__ection_
sedations10311253se_dations
seditions1039013se_ditions
seduction1266983seduction_
selachians1542503selachians
selectees1147013select_ees
selectionists1556023selectionists
selective1449523selecti_ve
selectman1343553selectman_
selectmen1344613selectmen_
selectness1245453selectness
selector1048613select_o_r
selects91912143select___s
selenious946963sele_nious
senecios1046303senec_io_s
sensations1059853sensations
seriations10316683seriations
serrations10313093serrations
siltations1038553siltations
skeletons1343933skele_t_ons
solations9814623sol_ations
solutions988883sol_utions
solvations1336833solvations
stictions1148353s_tictions
strictions1249143strictions
subjections2296353subjections
subsections1597103subsections
suctions103012903s__uctions
sulcations1289583sulcations
sulfations13107813sulfations
surjections2075283surjections
telethons1246023tele_thons

Search took 7 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 Filter1786911406030.420425454.8
2DLD Change Limit1406031406.47021731.5
3Display Results1401400.0761842.1
 (SQL Overall)1786911406.96625651.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.