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

188 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
congeries1231640(None) 
canneries11313082canneries
conferees14610622conferees
congees103517922conge__es
congers104223232conger__s
conserves14311192conserves
converges1538382converges
converses14311162converses
cookeries151210642cookeries
cooperies131113322cooperies
coteries10422712co_teries
dodgeries1246592dodgeries
doggeries1246672doggeries
forgeries13310002forgeries
lingeries10511812lingeries
monkeries15129912monkeries
toggeries1146212toggeries
angaries9314393_angaries
binderies12311693binderies
bobberies12107893bobberies
boiseries11411053boiseries
booteries11312793booteries
boweries13312293bo_weries
buggeries1347083buggeries
canaries10318943can_aries
canonries1148413canonries
catteries11815553catteries
causeries11510643causeries
cauteries11615403cauteries
celeries10316313c_eleries
centuries11311333centuries
chanceries1747653chanceries
cinerins10414103cin_erins
clowneries1544743clowneries
coagencies1545623coagencies
coderives1547483co_derives
codgers115113933codger__s
coerces11311943co__erces
cogencies1448103co_gencies
coheres122917693co_her_es
coinheres1447633coinher_es
collieries1248343collieries
comedies13311843co_medies
commerces17147233commerces
comperes143217973comper_es
concedes13311063conce_des
conceits122813613conce_its
conceives1639233conceives
concerned1438643concerned
concerns122710833concer_ns
concerted14312113concerted
concertizes24158583concertizes
concertos132711133concertos
concerts123016063concer_ts
conchies153214853con_chies
concierges1544553concierges
concretes13411473concretes
condenses12710133condenses
condores113315643condor_es
conferee13613733confer_ee
conferred1537753conferred
conferree1447793conferree
conferrees1546103conferrees
conferrer1447063conferrer
conferrers1546453conferrers
confers124120093confer__s
confervas1744823confervas
confesses1438623confesses
confreres1448033confreres
congealed1346593congealed
congealer1256703congealer
congealers1365673congealers
congeals11309863conge_als
congee96024473conge__e_
congeed113212313conge__ed
congeeing1337903congeeing
congener112412203conge_ner
congeners122511133congeners
congenial1248813congenial
conger95024273conger___
conges94928173cong___es
congested1338673congested
congests113510383conge_sts
congius103210073cong__ius
conglobes1444223conglobes
congoes103617303cong__oes
congrats11311433cong_rats
congress1138073cong_ress
congresses1348023congresses
conies84338593con___ies
conjures17119913conjur_es
conkers133721043conker__s
conners94023113conner__s
conniveries1644713conniveries
conscribes1645193conscribes
conserve1339933conserve_
conserved1538853conserved
conserver1448723conserver
conservers1547683conservers
conspires1358483conspires
construes11410133construes
contraries12711933contraries
contrives14311703con_trives
convenes132916913conve_nes
converge1437393converge_
converged1636973converged
converse13310263converse_
conversed1538683conversed
converser1438093converser
conversers1547353conversers
conversos1446893conversos
converted15311563converted
converter14311013converter
converters1539633converters
converts133213553conver_ts
convexes20278273conve_xes
coquetries2146023coquetries
corries94026803co__rries
corsetries1249663corsetries
coterie9417403co_terie_
countries11313613countries
covaries13413253co_varies
cowberries1744623cowberries
cowries124218013co__wries
crockeries1857123crockeries
crookeries1646143crookeries
cutleries1179213cutleries
cycleries1647033cycleries
doweries12411933do_weries
fineries112416753fin_eries
fooleries1248743fooleries
fopperies1666023fopperies
gingelies11277503gingelies
gorgerins1145193gorgerins
groggeries1354713groggeries
gunneries1047043gunneries
henneries1248643henneries
hongies112716473hong__ies
hosieries1249213hosieries
imageries1246783imageries
jaggeries18136973jaggeries
jobberies20115423jobberies
joineries1648103joineries
lingerie959203lingerie_
longerons1045893longerons
longers84819543longer__s
longies82916553long__ies
lotteries9311083lotteries
menageries1345853menageries
mockeries17128263mockeries
mongered1238953monger_ed
mongering13310353mongering
mongers104217273monger__s
monoecies1348863monoecies
monogenies1348793monogenies
moperies12313873mo_peries
nonheroes1247633nonheroes
nonjuries1645813nonjuries
nunneries947113nunneries
onerier7311613_on_erier
oneriest8313443_on_eriest
oogenies9311583_oogenies
orangeries11116943orangeries
orreries8310123_orreries
piggeries13107893piggeries
pineries102419083pin_eries
pongees104212543ponge__es
poperies12316793po_peries
potteries11313603potteries
robberies13107393robberies
rockeries15128973rockeries
rogueries1047003rogueries
rookeries13138173rookeries
roperies10315773ro_peries
roseries8317323ro_series
sceneries1149403scen_eries
sorceries1149943sorceries
surgeries10311363surgeries
tangerines1147543tangerines
tanneries9310423tanneries
tongers84116013tonger__s
veneries112815033ven_eries
vineries112716043vin_eries
voleries11313233vo_leries
waggeries14127463waggeries
wiggeries14136573wiggeries
wineries112316533win_eries
zoogenies1946833zoogenies

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411887.59319576.1
3Display Results1881880.0802350.0
 (SQL Overall)1786911888.09622071.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.