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

50 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
secateurs114272(None) 
secateur1042921secateur_
seaters74028942se_ate_rs
amateurs1043643_amateurs
beaters94925043be_ate_rs
caters85336503__cate_rs
debaters113511923debate_rs
decanters12229223decante_rs
decayers14307963decaye_rs
dewaters122910723dewate_rs
eaters65535953_e_ate_rs
ecotours1044463_ecotours
ecraseurs1141693_ecraseurs
elaters74420193_elate_rs
escapers12337413escape_rs
heaters104225223he_ate_rs
locaters102710073locate_rs
negaters9349783negate_rs
rebaters103413943rebate_rs
recanters112310483recante_rs
reciters102613113recite_rs
relaters83218153relate_rs
saboteurs1141863saboteurs
scalers93817263s_cale_rs
scaleups1243393s_caleups
scarers94618513s_care_rs
scatters103612753s_catters
scaurs85512053s_ca__urs
scepters1237793scepte_rs
scoters93313813s_cote_rs
sealers74323553se_ale_rs
seamers94719433se_ame_rs
seater64534163se_ate_r_
seawaters1235713seawate_rs
seceders11277963secede_rs
secretors1145843secretors
sectors93116453sec_t_ors
securers1057153secure_rs
sedater83713633sedate_r_
sedates83418043sedate__s
seigneurs1042493seigneurs
senates73322613senate__s
senators8312953senat_ors
setters73822063se_tte_rs
skaters113512963s_kate_rs
slaters73123733s_late_rs
socagers1196363socage_rs
specters122811063spec_te_rs
staters73922343s_tate_rs
sweaters113811063sweate_rs

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.450397091.1
2DLD Change Limit148641506.55022693.3
3Display Results50500.0133846.2
 (SQL Overall)178691507.01325480.0
 
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.