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

142 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
agencies113874(None) 
agenes74720252agen__es
ageneses939302ageneses
agenizes18269742agenizes
agentives1346442agentives
agentries1048232agentries
agonies83016622agon_ies
ardencies1247852ardencies
cadencies1447322cadencies
coagencies1545622coagencies
cogencies1448102cogencies
genies75324942_gen_ies
latencies1147772latencies
patencies1349172patencies
regencies1249282regencies
tangencies1345752tangencies
urgencies1256642urgencies
valencies1446412valencies
abbacies1445483abbacies
abeyancies1743043abeyancies
abhenries1444503abhenries
absences1247673absenc_es
adenines9310193adenines
adenoids1056863adenoids
adenoses947903adenoses
aeries64737783a_e_ries
agemates111110023agemates
agency1237033agenc__y
agendas936933agen_das
agendums1243443agendums
agene65621583agen__e_
agenesias1045363agenesias
agenesis938043agenesis
agenize172910153agen_ize
agenized19257733agenized
agented939423agen_ted
agential958153agential
agenting1039383agenting
agentings1134443agentings
agentive1248043agentive
agents74816293agen__ts
aggies83515513ag__gies
agnails837003ag_nails
agnates82813193ag_nates
agnizes17328843ag_nizes
agones75719863agon__es
agonise83112693agon_ise
agonises92613163agonises
agonizes182610583agonizes
agouties9337693agouties
akenes104817343aken__es
alencons1045473alencons
amenities11310433amenities
amentias1039413amentias
amerces1149853amerc_es
anergies9310453anergies
aperies9423203ape_ries
arenes64928393aren__es
arenites8917103arenites
argentines1146943argentines
argentites1147023argentites
atonies75320953aton_ies
aunties73920073a_unties
avenges1157543aven_ges
avenses1049643aven_ses
avenues1057183aven_ues
benches143918603_benches
bennies93917313_bennies
blenches153310763blenches
blennies1056933blennies
cadences1338473cadenc_es
clenches152910953clenches
decencies1448943decencies
denies74729643_den_ies
drenches14309803drenches
envies9314053__envies
exigencies2045263exigencies
faiences1337043faienc_es
fancies124018783_fancies
fences114617113_fenc_es
flenches163410533flenches
fluencies1445933fluencies
frenches163311633frenches
frenzies2037713frenzies
genes65133093_gen__es
geneses82613523_geneses
genie66124923_gen_ie_
genips9469943_gen_ips
genius74512923_gen_ius
genocides1345003_genocides
genoise839423_genoise
genoises939253_genoises
genomes103611703_genomes
genres75515623_gen_res
gentes75324163_gen_tes
gentiles93713523_gentiles
gentles83714343_gentles
gentries91315263_gentries
genuses83510883_genuses
gunnies83413123_gunnies
henries102718283_henries
jennies143511623_jennies
kenches163912273_kenches
lambencies1643803lambencies
legacies1139043legacies
lucencies1345843lucencies
mercies113817563_mercies
nancies93516843_nancies
nascencies1444553nascencies
oogenies9311583oogen_ies
pencils113011773_pencils
pennies94218813_pennies
plangencies1653793plangencies
plenches153110623plenches
plenties10314693plenties
potencies1369303potencies
pudencies1445783pudencies
pungencies1544723pungencies
quenches2236013quenches
recencies13312253recencies
saliencies1246133saliencies
sapiencies1445113sapiencies
species11314133spe_cies
spences113413923spenc_es
stenches132110293stenches
stencils1046403stencils
subagencies1653483subagencies
tangences1246443tangenc_es
tenches123515523_tenches
tennies73017973_tennies
trenches133512603trenches
trendies9312213trendies
turgencies1345513turgencies
twenties1137503twenties
vacancies1645493vacancies
vagrancies1644173vagrancies
valences1388513valenc_es
valencias1443633valencias
weenies102915093ween_ies
wenches152914133_wenches
wienies102213683wien_ies
wrenches163210233wrenches

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 Filter1786911461620.250714764.0
2DLD Change Limit1461621427.14020470.9
3Display Results1421420.0632254.0
 (SQL Overall)1786911427.45323975.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.