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 “narceines” 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
narceines114658(None) 
narceine1046751narceine_
narceins1036411narcein_s
archines133815252_archines
arcsines104010342_arcsines
larcenies1147532larcenies
narcein936292narcein__
anarchies1448183anarchi_es
archine125817053_archine_
archings14499863_archings
archives16399553_archives
arcsine94512393_arcsine_
arenes64928393_ar_e_nes
arsines73518813_ar_sines
caffeines1743913caffeines
calcines12314753calc_ines
carabines13311463carabines
carbines123617533car_bines
carlines103521643car_lines
carmines123617863car_mines
croceines1347733croceines
farcies125317883farc_i_es
fascines13310143fasc_ines
harmines132715143har_mines
larcener1036493larce_ner
larceners1135993larce_ners
machines15312893ma_chines
marines93928013mar__ines
marlines103818713mar_lines
nacelles1048393na_celles
nancies93516843nanc_i_es
narcisms1267263narc_isms
narcists1078113narc_ists
narcoses103910543narc_oses
narcotizes2164433narcotizes
nardine82712573nar_dine_
narghiles1343543narghiles
nargiles976793nar_giles
narine63422553nar__ine_
nascences1346233nascences
nereides938503ner_eides
nervines112310463ner_vines
orceins937743_orcein_s
parcener1238473parce_ner
parceners1337453parce_ners
perceives1646313perceives
sarcenet10413313sarce_net
sarcenets1146953sarce_nets
sarcinas1039273sarc_inas
sardines92815563sar_dines
sparteines12105173sparteines
tacrines10310563ta_crines
vaccines1536503va_ccines

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.420425454.8
2DLD Change Limit148641536.72022119.2
3Display Results53530.0163312.5
 (SQL Overall)178691537.15624970.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.