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

73 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
naivete105566(None) 
naivetes1145111naivetes
naivety1344281naivety
naive85116212naiv__e
naively1335902naively
naiver94311352naive_r
naives94914222naive_s
naivest10309472naivest
naiveties1245432naiveties
navette1036982na_vette
aiver85725163_aive_r
aivers94822323_aivers
animate91617213animate
anisette846773anisette
arete56031353_a_rete
aviate9315203_aviate
bailee84526013baile_e
civet105828733_civet_
civets115212543_civets
facete115014833fa_cete
gaiety10119373gai_ety
gamete9313593ga_mete
grivet103517823grivet_
grivets11357973grivets
jayvee1957613jayve_e
kainite1149543kainite
machete14310883machete
nailed74021493naile_d
nailer64119363naile_r
nailers73215893nailers
nailset7311973nailset_
nailsets834553nailsets
naiveness1277493naiveness
narrate7313493narrate
native9613013nativ__e
natively1446413natively
natives10310823native_s
nativity1446633nativity
nauseate845893nauseate
nave75732313na_v__e
navel87016573na_ve_l
navels95712693na_vels
naves87030383na_ve_s
navettes1136613na_vettes
navies95218623navie_s
navigate1246073navigate
nervate1039533nervate
nicety1138433n_icety
nidate7313783n_idate
niece74814503n_i_ece
nieve85613183n_i_eve
ninety9510963n_inety
nite45943583n_i__te
noisette846313noisette
private121513263private
privet113821343privet_
privets122910053privets
rivet85636363_rivet_
riveted11258573_riveted
riveter10208753_riveter
rivets94417113_rivets
salivate11310013salivate
savate9313783sa_vate
swivet123615473swivet_
swivets13436963swivets
trivet93721883trivet_
trivets103911583trivets
valvate133710813valvate
waive114214603waiv__e
waived134511283waive_d
waiver124212713waive_r
waivers133410053waivers
waives123714183waive_s

Search took 7 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 Filter1786911340270.390458182.1
2DLD Change Limit134027735.91022678.0
3Display Results73730.0135615.4
 (SQL Overall)178691736.31328305.2
 
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.