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

80 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
lucarne94426(None) 
lucarnes1045091lucarnes
lucerne945751lucerne
eucaine939242eucaine
lucern846102lucern_
lucernes1046362lucernes
lucerns935752lucerns
lucre76415522luc_r_e
acarine9316003_acarine
arcane81216743arca_ne
bicorne11297553bicorne
butane8313653buta_ne
cane66653123__ca_ne
care66968373__car_e
carle74535703__carle
carn66245433__carn_
carnet84732873__carnet
carney115315703__carney
carnie84421093__carnie
carns75937563__carns
carny105822923__carny
carse74934333__carse
carte75940423__carte
carve106227753__carve
cocaine111315173cocaine
crane75331603__crane
curare84916953curar_e
curarine10610713curarine
decane93818873deca_ne
decare93919153decar_e
ecarte84313503_ecarte
eucaines1038513eucaines
euchre11137663euchr_e
furane94015493fura_ne
glucan936183gluca_n_
glucans1045293gluca_ns
humane112812173huma_ne
lactone9311393lactone
lacune8169673lac_une
lane45153333l__a_ne
laree56036293l__aree
large65325463l__arge
larine63927043l__arine
lasagne844063lasagne
learn55322663l_earn_
learned8329303l_earned
learner7319383l_earner
learns65513743l_earns
learnt64019253l_earnt
leucine938073leuc_ine
liane54720663l_ia_ne
lierne638023l_ierne
locale83915653loca_le
locate83919843loca_te
luce65132573luc___e
lucence11148003lucence
lucent8313823luc_ent
lucite8313343luc_ite
luckie123611413luc_kie
lucking143615833lucking
lucres84513303luc_res
lunar57017313lunar__
lunars65012813lunar_s
lunate6316043luna_te
lune47140493lu___ne
lupine84013533lu_pine
lurdane835983lurdane
lure45142463lu__r_e
lustre64011683lustr_e
luxate1338083luxa_te
muscarine1346013muscarine
pugaree10208033pugaree
quare143920543qu_ar_e
quarte154115323qu_arte
recane83022873reca_ne
scarce104013633_scarce
scare75334463_scar_e
sucrase9310343sucrase
sucre75019103suc_r_e
urare56322553_urar_e

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.403443402.0
2DLD Change Limit134027806.11021935.7
3Display Results80800.0332424.2
 (SQL Overall)178691806.54627297.7
 
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.