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 “nevi” with Change Limit: [1] [2] [3]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

78 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
nevi7511642(None) 
naevi867871naevi
neve76224831neve
bevy127115222bevy
cedi74919272cedi
defi86321492defi
deli55631292deli
deni56929392deni
dev76033772dev_
deva85720982deva
devil94714732devil
devs86424032devs
envoi878022envoi
envy10411252envy
eve66331162_eve
evil75318072_evil
kepi105315632kepi
kevil12399862kevil
lei36846382le_i
lev66139422lev_
leva77020712leva
levin84816412levin
levis85818552levis
levo76820062levo
levy106418502levy
naoi46024632naoi
nave75732312nave
navy107518632navy
nazi136219872nazi
ne27045102ne__
neap66927012neap
near45236502near
neat46356782neat
neb57238622ne_b
nebs66124982nebs
neck105423662neck
nee36657782ne_e
need54934152need
neem67328082neem
neep65728312neep
neg47237342ne_g
negs55727362negs
neif75429492neif
nema65522522nema
nene45932062nene
neon47026422neon
nerd56624942nerd
nerve86617372nerve
nervy114610862nervy
ness45526562ness
nest45548732nest
net36670292ne_t
nets45941532nets
nett46643232nett
neuk87416602neuk
neum66723082neum
never86218642never
neves87021872neves
nevoid1098802nevoid
nevus84611392nevus
new66237092ne_w
newie81813482newie
news76127372news
newt76933742newt
next116631082next
nidi56524402nidi
nieve85613182nieve
nisi45823242nisi
nodi56626742nodi
nori47133142nori
nova76518952nova
peri65636972peri
rei35647252re_i
rev65336622rev_
revs75027052revs
sei36048932se_i
semi65127222semi
yeti75823212yeti

Search took 2 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 Filter178691298720.283631417.0
2DLD Change Limit29872780.90333080.8
3Display Results78780.0164875.0
 (SQL Overall)178691781.202148661.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.