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

55 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
elicitors114580(None) 
elicitor1045771elicitor_
electors103013842elec_tors
elicits9311232elicit__s
evictors13276852evic_tors
excitors1746092e_xcitors
felicitous1543752felicitous
lictors93212592_lic_tors
solicitors1244212solicitors
dedicators1447743dedicators
delicious1246713delici_ous
delimiters1345103delimiters
depictors1465943depic_tors
editors839423e__ditors
educators1246993educators
eductors1135983educ_tors
ejectors17328663ejec_tors
elections112414973elections
elector93313253elec_tor_
electros102811743elec_tros
elevators1246303elevators
elicit8417203elicit___
elicited1139093elicit_ed
eliciting1237773eliciting
eliminators1344813eliminators
elisions82210423elisi_ons
elixirs1443543elixi__rs
elucidators1453183elucidators
enactors1038453enac_tors
epilators1149433epilators
erectors103514263erec_tors
evictions14228623evictions
evictor12346363evic_tor_
evocators1446713evocators
exactors1737013exac_tors
exciters1736323e_xciters
excitons1746043e_xcitons
excitor1645993e_xcitor_
executors1844653executors
exhibitors2252793exhibitors
explicators2244713explicators
felicitators1752573felicitators
felicities1549743felicities
flichters1774173flichters
helicities1549853helicities
lectors93415763_lec_tors
lictor83610853_lic_tor_
limiters10249333_limiters
locators102910433_locators
relictions12310023relictions
selectors1148963selec_tors
solicitor1144403solicitor_
solicitous1244173solicitous
victors123311183_vic_tors
visitors1146433_visitors

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 Filter1786911486410.403443402.0
2DLD Change Limit148641556.48622917.2
3Display Results55550.0301833.3
 (SQL Overall)178691556.91925826.1
 
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.