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

262 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
kerseys143399(None) 
jerseys1733241jerseys
kersey1336791kersey_
erses55826802_erse_s
jersey1636332jersey_
kermes124616132kerme_s
kermess13396222kermess
kernels11417952kernels
kernes104717532kerne_s
keysets1434342keysets
perses85428062perse_s
versers103813522versers
verses94223762verse_s
versets103913102versets
aeries64737783aerie_s
arses55733873_arse_s
barleys125011843barleys
barneys12569563barneys
berets85822523ber_ets
bermes106023003berme_s
berseem1166463berseem
berseems1263933berseems
berserk1334913berserk
berserks1433993berserks
beses75830723be_se_s
besets85718803be_sets
birses84717733birse_s
burleys12479673burleys
burses84425513burse_s
carneys124310543carneys
carses85233653carse_s
causeys12387223causeys
ceases84427073cease_s
censers94313903censers
censes83721803cense_s
ceres75540013cer_e_s
cereus85215523cer_eus
cerises94722253cerise_s
cermets1139713cermets
certes84623083certe_s
ceruses93716233ceruse_s
cesses84221363cesse_s
corses84433463corse_s
corsets94819803corsets
coseys115215813_coseys
cursers94317163cursers
curses85328273curse_s
curtseys1342743curtseys
darkeys15356533darkeys
derays105514253der_ays
dorsels84412573dorsels
dorsers83516303dorsers
easels65914553_easels
eases56041613_ease_s
erasers74413943_erasers
erases64425403_erase_s
ernes55224813_erne_s
eroses65327053_erose_s
eses45336103_e_se_s
essays965653_essays
esses56422973_esse_s
feases95422923fease_s
feres86038183fer_e_s
ferrels10248623ferrels
ferrets103111393ferrets
fesses94820253fesse_s
garveys14124463garveys
germens1078633germens
geysers1135703geysers
gorses74723293gorse_s
greys96614853_gr_eys
guernseys1381033guernseys
gurneys11406463gurneys
hearsays1444513hearsays
hearses104414533hearse_s
henleys1334843henleys
herders113914123herders
heres86245903her_e_s
heresy125011233heresy_
heroes94923823heroe_s
herpes115517323herpe_s
herself1337623herself
heydeys1732863heydeys
hirsels10128343hirsels
horses94729343horse_s
horsey125115403horsey_
hoseys124614003_hoseys
hurleys13407333hurleys
jarveys20123413jarveys
jereeds15326393jereeds
jerkers18287083jerkers
jerseyed1942743jerseyed
jesses135215953jesse_s
kaisers11369273kaisers
karsts106012943kars_ts
kedges124812983kedge_s
keefs125116283ke__efs
keeks84717253ke__eks
keels94622413ke__els
keeners113610783keeners
keens95721183ke__ens
keepers133410983keepers
keeps116020283ke__eps
keesters12319593keesters
keets95123483ke__ets
keeves133711993keeve_s
keggers13357043keggers
keglers12277773keglers
keisters123212043keisters
keleps12478813ke_leps
kelsons1137323kelsons
kelters113813753kelters
kennels11387193kennels
kentes105118653kente_s
kerbed13339703kerbe_d
kerbs115013673ker__bs
kerfed14358233kerfe_d
kerfs125413573ker__fs
kermesse14303483kermesse
kermis124012393ker_mis
kermises14248313kermise_s
kerne94718223kerne__
kerned114112933kerne_d
kernel104010593kerne_l
kerns94719563ker__ns
kerogens1345763kerogens
kerosene1254823kerosene
kerosenes1345453kerosenes
kerrias11289513kerrias
kerries113317913kerries
kerry124916093ker_ry_
ketoses114912873ketose_s
kevels134410713ke_vels
kexes166216823ke_xe_s
keyless1436163keyless
keys116322163k___eys
keyset13411533keyse_t
keysters15326333keysters
keyways2043373keyways
kidneys1533423kidneys
kirmess13234313kirmess
kissers114211293kissers
kisses104217333kisse_s
knessets1243173knessets
kreeps12427413k_reeps
krewes1337923krewe_s
krises105016083krise_s
kvases13467103kvase_s
kyries133411373kyrie_s
leasers74717843leasers
leases65428113lease_s
lenses64620893lense_s
leses54930813le_se_s
lessees73510243lessees
lessens7409383lessens
linseys1035083linseys
marses84827113marse_s
medleys13115333medleys
menses84222453mense_s
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
meres75143573mer_e_s
mergees104411233mergees
mergers103813423mergers
merges94122493merge_s
merises93421423merise_s
merles85322763merle_s
messes84924343messe_s
morsels94112653morsels
moseys114711703_moseys
murreys12367323murreys
nereis6315343ner_eis
nerves94216193nerve_s
nesses64718323nesse_s
nursers74311833nursers
nurses63919353nurse_s
oersteds934373oersteds
overseas112612423overseas
oversees112415903oversees
oversets113114173oversets
oversews14289423oversews
parleys125212373parleys
parsecs11429923parsecs
parsers94118153parsers
parses85534703parse_s
parsleys1335083parsleys
peases85229473pease_s
peaveys15324063peaveys
peises84125043peise_s
pensees9311203pensees
peres76246643per_e_s
perse75429523perse__
persons93717013persons
perusers10328803perusers
peruses94018163peruse_s
presets94216423presets
preys105717783_pr_eys
pursers93916093pursers
purses84826373purse_s
purveys15615903purveys
rekeys13347693re_keys
rerises73525883rerise_s
resays93714153re_says
resees63827483re_sees
resets65427613re_sets
resews94814173re_sews
reuses66025523reuse_s
sarsens7311393sarsens
seisers73816393seisers
seises64026713seise_s
senseis73310643senseis
senses63923943sense_s
sepses84515883sepse_s
seres55448893ser_e_s
sergers83815633sergers
serges74225973serge_s
series64540973serie_s
servers103214833servers
serves94423653serve_s
surreys10489443surreys
surveys13357573surveys
teasels74311313teasels
teasers75317243teasers
teases65426273tease_s
tenses64722553tense_s
tercels94110363tercels
terces83921413terce_s
tercets93512443tercets
termers95414503termers
ternes65422903terne_s
terrets72913583terrets
terse55026823terse__
tersely1038113tersely
terser67317823terse_r
tersest71713993tersest
torses64727953torse_s
treys85018213_tr_eys
turkeys1434523turkeys
vergers114412633vergers
verges104320183verge_s
vermes115019143verme_s
verse84723583verse__
versed104515513verse_d
verser94516963verse_r
verset94327323verse_t
versos93812803vers_os
verstes104014283verstes
versts93914733vers_ts
versus94211143vers_us
verves124617883verve_s
vervets13419753vervets
vessels1035933vessels
weasels10468503weasels
worsens104610263worsens
worses95522953worse_s
worsets105512843worsets
xeroses143612823xerose_s
xeruses143010753xeruse_s
yeses85119323ye_se_s
yesses93615813yesse_s
zeroes154314343zeroe_s

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272626.03022226.7
3Display Results2622620.0932817.2
 (SQL Overall)1786912626.52927368.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.