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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

53 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
selectees114701(None) 
electees10238721_electees
selectee10910491selectee_
electee92513242_electee_
rejectees18235422rejectees
selected1159782select_ed
selectmen1344612selectmen
selectness1245452selectness
selectors1148962selectors
selects91912142select__s
celestes10310013celest_es
delectates1348193delectates
delegatees1244273delegatees
deletes83117933dele_t_es
detecters12217753detecters
elected102812613_elect_ed
electives1448933_electives
electors103013843_electors
electress1146113_electress
electret10411993_electret
electrets1146543_electrets
electros102811743_electros
elects83315003_elect__s
erecters102611613_erecters
evictees1344583_evictees
neglecters1362933neglecters
rejectee17289623rejectee_
rejecters18257543rejecters
reletters9138783reletters
relocatees1275223relocatees
seethes103613743se_e_thes
select82621173select___
selecting12310533selecting
selection11311273selection
selections12310873selections
selective1449523selective
selectly1346563select_ly
selectman1343553selectman
selectnesses1446113selectnesses
selector1048613select_or
selenates91611353selenates
selenides10178193selenides
selenites91312083selenites
selenoses947463selenoses
semesters1139123semesters
settees73513633s__ettees
seventeen1243913seventeen
seventeens1342843seventeens
seventies1249673seventies
solecises1189103solecises
solecizes2087863solecizes
specters122811063s_pecters
spectres12268683s_pectres

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 Filter1786911486410.423422437.4
2DLD Change Limit148641538.54617393.0
3Display Results53530.0301766.7
 (SQL Overall)178691538.99919856.8
 
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.