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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

140 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
recency143863(None) 
decency1537451decency
regency1337361regency
lucency14104902lucency
recent83630852recen_t
recently1339422recently
recreancy1643782recreancy
redeny102712732reden_y
refence12312232refence
reticency1644572reticency
agency1237033_agency
ardency1346483ardency
brevetcy1841723brevetcy
cadency1545893cadency
clemency1743693clemency
cogency1547013cogency
credence1387823credence
decadency1863673decadency
decenary1446273decenary
decent94023703decen_t
decently1448013decently
defence1339893defence
errancy1256363errancy
evenly1236993_evenly
fervency1944383fervency
fluency1545353fluency
frequency2653403frequency
greenly11408193gre_enly
greeny104811453gre_en_y
indecency1745383indecency
keenly1336373ke_enly
latency1236033latency
leniency1345313leniency
licence11119363licence
lucence11148003lucence
nascency1543693nascency
patency1466313patency
peccancy1643953peccancy
pendency1646073pendency
potency1457433potency
precedency2053693precedency
precent113520263precen_t
precents123015043precents
precinct1459423precinct
presence122213513presence
pretence122312123pretence
pudency1544763pudency
raceway1546133raceway
rebec94416543rebe_c_
rebeck14419913rebe_ck
rebecs103913673rebe_cs
recane83022873recan_e
recaned102817203recaned
recanes93222263recanes
recant83228683recan_t
recants93217093recants
recarry1245063recarry
recce9514563rec__ce
recede95515533rece_de
receded112713043receded
recedes102816063recedes
receipt1159253receipt
receive1239733receive
recencies13312253recencies
recensor1045543recensor
recenter102715443recenter
recept103319073rece_pt
recepts113010263recepts
recess8314263rece_ss
recheck1835613recheck
recock145112723rec_ock
recon75624243recon__
recons84922993recon_s
reconvey1655603reconvey
recopy1339043rec_opy
recreance1346993recreance
rectify1536453rectify
rectory123512733rectory
recumbency2152493recumbency
recusancy1643743recusancy
redefy13388763rede_fy
redneck1445113redneck
redolency1544013redolency
reechy14367823re_echy
reedy910020293re_e_dy
reefy114217703re_e_fy
reeky125416263re_e_ky
reenact9413013re_enact
reenjoy1743293re_enjoy
reentry1038033re_entry
refect114319333refe_ct
refenced1438993refenced
refences13311843refences
regent74127673regen_t
regents83416543regents
regnancy1444773regnancy
reject154116283reje_ct
rekey124014733reke__y
relend76116453relen_d
relends84013253relends
relent64431853relen_t
relents74018503relents
relevancy17134043relevancy
remedy1237873reme_dy
remend95216553remen_d
remends105013033remends
renitency1445443renitency
repent84728873repen_t
repents93717623repents
rerent63832453reren_t
rerents73319423rerents
resect84424703rese_ct
resend75016773resen_d
resends83513713resends
resent63833623resen_t
resents74221223resents
residency1565513residency
resiny94617363resin_y
reteach1237413reteach
retene69224273reten_e
retenes76324623retenes
reticence1347623reticence
retrench1346283retrench
revelry1335693revelry
revenge1138573revenge
revenue1039533revenue
revery124014213reve_ry
secrecy1444743secrecy
sequency2244493sequency
seventy1338033seventy
teensy9478273te_ensy
teeny85417883te_en_y
tenancy1237503tenancy
tendency1445493tendency
trecento1066213trecento
urgency1345663urgency
vacancy1744443vacancy
valency1565463valency
weensy12416823we_ensy
weeny115316163we_en_y

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 Limit1340271406.83019623.3
3Display Results1401400.0463043.5
 (SQL Overall)1786911407.26624592.8
 
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.