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

71 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
narrators94786(None) 
barrators1148391barrators
narraters946691narraters
narrator847561narrator_
aerators8315612_aerators
barraters1138032barraters
barrator1048402barrator_
barretors1146242barretors
narrater838722narrater_
narrates8312752narrat_es
narrations1038932narrations
nitrators949202nitrators
warrantors1343042warrantors
abators94413073_a_bators
ablators1069873_ablators
aerator7314843_aerator_
animators111210413animators
arrayers11125853_arrayers
arrestors958013_arrestors
arrogators1145363_arrogators
aviators11169903_aviators
barrater10310143barrater_
barratry13114473barrat_ry
barretor1046713barretor_
castrators1247433castrators
caveators1497253caveators
creators102814383_creators
curators10311703_curators
deaerators11107713deaerators
enervators1345703enervators
farragoes1344633farragoes
garroters1055813garroters
gyrators1245993_gyrators
hydrators1645683hydrators
labradors1243783labradors
laudators1045883laudators
macerators14167483macerators
mandators1247863mandators
marcatos1249163marcato_s
marranos1038403marrano_s
migrators1247523migrators
narrate7313493narrat__e
narrated9310323narrat_ed
narrating10310343narrating
narration9310063narration
narrative1247373narrative
narratives1344793narratives
narrows10258843narr__ows
natatory1146603na_tatory
navigators1464823navigators
negators92411153n_egators
nitrator849553nitrator_
numerators1245553numerators
operators11410753operators
orators7313803__orators
palpators1346793palpators
paradors113411893pa_radors
parroters1156763parroters
perorators1249343perorators
radiators1049313radiators
sartors7314953sa_r_tors
saturators1046083saturators
tarragons1044473tarragons
titrators948353titrators
valuators1286443valuators
varactors1446383varactors
varistors1246513varistors
vibrators14237243vibrators
warranters1344523warranters
warrantor1243213warrantor_
warriors1135363warr_iors

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.1561145455.1
2DLD Change Limit148641719.40615802.8
3Display Results71710.0302366.7
 (SQL Overall)178691719.59218629.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.