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

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

43 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
ergates831449(None) 
ergate7315141ergate_
aerates74627502aer_ates
agates76121342_agates
berates94126882ber_ates
cerates95428252cer_ates
crates85736062cr_ates
creates95225212creates
derates84028892der_ates
derogates11310972derogates
elates65032362e_lates
eluates72014682eluates
enates64026432e_nates
engages92912492engages
equates162012322equates
erases64425402er_ases
ergatives1346442ergatives
ergots74512372ergot_s
erratas736862erratas
ersatzes1743072ersatzes
estates74520182estates
ferrates113013422ferrates
frigates12310932frigates
gates65939512__gates
grates75429892gr_ates
ingates82716912ingates
legates82917682legates
ligates82318382ligates
negates83215842negates
orates64328612or_ates
prates84633162pr_ates
rates55352012_r_ates
rebates95123192rebates
redates83423882redates
regales83520792regales
regrates92618412regrates
relates73731442relates
remates93827122remates
seriates82620682seriates
serrates82617022serrates
tergites9310542tergites
urates65027762ur_ates
virgates1237922virgates

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit107671433.23333303.7
3Display Results43430.0162687.5
 (SQL Overall)178691433.62549294.1
 
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.