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

61 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
naivetes114511(None) 
naivete1055661naivete_
naiveties1245431naiveties
naiveness1277492naiveness
naives94914222naiv__es
naivety1344282naivet_y
navettes1136612na_vettes
aivers94822323_aive_rs
animates101316423animates
anisettes946673anisettes
aretes64425353_a_retes
aviates10313063_aviates
bailees93914383baile_es
civets115212543_civet_s
diabetes1147023diabetes
gaieties9310183gai_eties
gametes10312253ga_metes
grivets11357973grivet_s
jayvees2052923jayve_es
kainites1238793kainites
machetes1539633machetes
naiades838213nai_ades
nailers73215893naile_rs
nailsets834553nailset_s
naive85116213naiv__e_
naively1335903naive_ly
naiver94311353naiv__er
naivest10309473naive_st
narrates8312763narrates
nates55238333na___tes
nativeness1357833nativeness
natives10310823nativ__es
nativities1348433nativities
nauseates946213nauseates
navels95712693na_ve_ls
naves87030383na_v__es
navette1036983na_vette
navies95218623na_v_ies
navigates1345873navigates
navvies1335323na_vvies
niceties10310863n_iceties
nidates8311893n_idates
nieces84112713n_i_eces
nieves94311293n_i_eves
nineties8312913n_ineties
nites55736343n_i__tes
niveous1037193n_iveous
noisettes946533noisettes
parietes10714543parietes
privates131812373privates
privets122910053privet_s
riveted11258573_riveted
riveter10208753_riveter
riveters11228163_riveters
rivets94417113_rivet_s
salivates1239293salivates
savates10312953sa_vates
swivets13436963swivet_s
trivets103911583trivet_s
waivers133410053waive_rs
waives123714183waiv__es

Search took 9 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 Filter1786911461620.406440125.6
2DLD Change Limit146162617.59319249.6
3Display Results61610.0331848.5
 (SQL Overall)178691618.03222247.4
 
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.