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

207 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
agency123703(None) 
agedly1136462agedly
agenda837252agenda
agene65621582agen_e
agenes74720252agenes
agent65829642agen_t
agentry11165752agentry
agents74816292agents
agony96415652agon_y
ardency1346482ardency
cadency1545892cadency
coagency1644862coagency
cogency1547012cogency
latency1236032latency
patency1466312patency
regency1337362regency
tangency1444562tangency
urgency1345662urgency
valency1565462valency
abbacy1536623abbacy
abeyancy1853053abeyancy
abhenry1543333abhenry
absence1137703absence
adenyl1035023adenyl
adunc837433adunc_
aery77231683a_e_ry
age47154333age___
aged67334253age__d
agee56241493age__e
ageing84213403ageing
ageings9437693ageings
ageism968803ageism
ageist7315383ageist
agencies1138743agencies
agendas936933agendas
agendum1144673agendum
agenize172910153agenize
agented939423agented
ager55935843age__r
agers65027853age_rs
ages55844593age__s
agin56132713agin__
aging77026353agin_g
agings86312673agings
agley96917333ag_ley
agly86821803ag__ly
agon56531883agon__
agonal7410053agonal
agone65924553agon_e
agones75719863agones
agonic93515143agonic
agons66423783agon_s
agouty10366913agouty
akene95818663aken_e
akenes104817343akenes
alec66430063ale_c_
alecs76620733ale_cs
alencon945733alencon
alienly1037503alienly
amen66733153amen__
amend85717753amen_d
amends94713283amends
amenity1238333amenity
amens75624843amen_s
ament76036543amen_t
aments85219803aments
amerce10310513amerce
anenst63514983anenst
anent54931843anen_t
anergy10156863anergy
angerly1137773angerly
annoy869713a_nnoy
any68440483a__n_y
apercu1057383apercu
apery106517903ape_ry
aplenty1237173aplenty
areca75618633are_ca
areic73219393areic_
arena55323813aren_a
arenas65021993arenas
arene55329413aren_e
arenes64928393arenes
argent74023663argen_t
argents84014853argents
atony87218853aton_y
augend837633augen_d
augends935883augends
aunty85919813a_unty
avenge1087553avenge
avens86419333aven_s
avenue957953avenue
aweary1237303aweary
awny105919303a_wn_y
axenic154210003axenic
bench125619503_bench
bendy115017253_bendy
benny105217363_benny
blench133710453blench
blenny1156203blenny
bouncy13409073bouncy
cadence1239063cadence
cagey115917823cage__y
chancy164010863chancy
clench133910053clench
decency1537453decency
deny86027123_den_y
drench12369593drench
eagerly1136053eagerly
envy10411253__envy
evenly1236993evenly
exigency2144723exigency
faience1237513faience
fancy134615483_fancy
fence105319913_fence
fenny115115133_fenny
fleecy14266483fleecy
flench144010813flench
fluency1545353fluency
french143511213french
frenzy2135883frenzy
gaen57329603gaen__
gainly1049323gainly
geck115721993_ge_ck
geeky134710733_geeky
gemmy135211053_gemmy
gen45950513_gen__
gene56237223_gen_e
genes65133093_genes
genet66038683_genet
genic85119393_genic
genie66124923_genie
genii64514173_genii
genip84415203_genip
genoa64315823_genoa
genom83716843_genom
genre66016803_genre
genro64914033_genro
gens55740073_gen_s
gent56954393_gen_t
gently103710913_gently
gentry103410443_gentry
gents65729613_gents
genu55929073_gen_u
genua64614153_genua
genus65319833_genus
germy115113663_germy
gey75738303_ge__y
ginny95314573_ginny
gunky135514113_gunky
gunny94413663_gunny
hence104920043_hence
henry114014473_henry
jenny153811623_jenny
jouncy18336203jouncy
keenly1336373keenly
kench145513923_kench
lagend838743lagen_d
lagends947273lagends
lambency1743203lambency
legacy1256653legacy
lucency14104903lucency
magenta1038623magenta
mercy125916183_mercy
mincy125817413_mincy
nancy105214923_nancy
nascency1543693nascency
oogeny10117923oogen_y
openly1137123openly
pageboy1543873pageboy
pence94924453_pence
penny105119453_penny
plangency1742803plangency
plench134010813plench
plenty11311413plenty
potency1457433potency
pudency1544763pudency
pungency1644093pungency
quench2036633quench
recency1438633recency
sagely102811383sage_ly
saliency13125393saliency
sapiency15114493sapiency
spence103813793spence
spendy124911143spendy
stench114111163stench
stenchy15256213stenchy
subagency1753153subagency
tangence1146703tangence
teensy9478273teensy
teeny85417883teen_y
tench105620003_tench
tenty86121603_tenty
thence112010843thence
trench114211613trench
trendy10469603trendy
turgency1444833turgency
twenty1236223twenty
vacancy1744443vacancy
vagrancy1743453vagrancy
valence1268773valence
weensy12416823weensy
weeny115316163ween_y
wench136214783_wench
wenny114412463_wenny
whence14187923whence
wrench14439353wrench
zincy195413513_zincy

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 Filter1786911127160.216827273.1
2DLD Change Limit1127162076.03318683.2
3Display Results2072070.0603450.0
 (SQL Overall)1786912076.30928323.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.