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

38 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
nirvana104284(None) 
nirvanas1142511nirvanas
nirvanic1342252nirvanic
pirana8713262pir_ana
airman82414223airman_
arcana8912583_arcana
biriani945643biriani
biryani1244033biryani
corvina12229503corvina
divan96114843di_van_
divans104612393di_vans
firman112211343firman_
firmans12238523firmans
grana65722093_gr_ana
hariana10310243hariana
hiragana1242893hiragana
iguana735813_iguana
liana53915893li__ana
nagana748943n_agana
nana46632903n___ana
nervate1039533nervate
nervine102510633nervine
nerving112910833nerving
nival84915773ni_va_l
norland837163norland
novena936763n_ovena
organa789213_organa
piranas9912613pir_anas
piranha12126363pir_anha
piraya1167713pir_aya
purana8712933pur_ana
ruana5312423__ruana
sardana838643sardana
servant10313633servant
silvan92810153silvan_
silvans10308333silvans
tartana73010193tartana
timpana11226133timpana

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 Filter1786911340270.390458182.1
2DLD Change Limit134027386.89319443.9
3Display Results38380.0162375.0
 (SQL Overall)178691387.29924481.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.