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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
nacres8561445(None) 
acres76327761_acres
naches114622411naches
nacre75715361nacre_
nacred95212491nacred
nares55544151na_res
aces67645092_ac_es
aches106132292_aches
acmes96020652_acmes
acnes75922622_acnes
acre67330772_acre_
acred87126352_acred
ancress978612ancress
antres65021002antres
apres75426402_apres
ares45871022_a_res
aures55137092_aures
baches135426942baches
bares75457132ba_res
barres84427542barres
caches137926912caches
cadres94017932cadres
cares77369182ca_res
daces85030682dac_es
dares66146702da_res
eagres74014572eagres
facers115519442facers
faces106439432fac_es
facies113921592facies
farces115223322farces
fares85852872fa_res
fiacres1237252fiacres
haeres94017032haeres
hares86255542ha_res
lacers85225252lacers
laces76141762lac_es
laches116528352laches
lares54852632la_res
lucres84513302lucres
macers105321272macers
maces97139962mac_es
maches134827232maches
macles107023222macles
macros104017012macros
madres93718182madres
mares76457632ma_res
matres84522232matres
nabes75427092na_bes
nachas114914192nachas
nachos115014182nachos
nacreous1045762nacreous
nairas6312782nairas
nairus639142nairus
naives94914222naives
namers84517332namers
names74833362na_mes
nances83618642nances
nancies93516842nancies
napes74828462na_pes
nappes104515622nappes
narcos86714202narcos
narcs76122022na_rcs
nards65928462na_rds
naris55735292na_ris
narks96026032na_rks
nates55238332na_tes
natures7311962natures
naves87030382na_ves
navies95218622navies
niches114419142niches
nitres65519332nitres
pacers105124542pacers
paces96741112pac_es
padres95016982padres
pares77164482pa_res
racers84725432racers
races74943242rac_es
rares55247442ra_res
sabres85520862sabres
sacred94917102sacred
scares85033002scares
snares65329032sna_res
sucres84218892sucres
taces76237802tac_es
taches114224172taches
tares57456562ta_res
tarres64723042tarres
wackes154717712wackes
wares88250582wa_res
zaires1539702zaires

Search took 3 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 Filter178691825510.343520965.0
2DLD Change Limit82551902.42334069.7
3Display Results90900.0303000.0
 (SQL Overall)178691902.79663909.5
 
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.