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

195 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
erlkings133356(None) 
erlking1236701erlking_
brokings15317712brokings
calkings15289222calkings
talkings13358402talkings
walkings16327312walkings
ablings1038743abl_ings
alkines114415733_alkines
archings14499863archings
arcking145811963arcking_
armings103811503ar_mings
askings12519173_askings
backings174012213backings
bakings144312023_bakings
balking143717353balking_
bankings15489403bankings
bellings113811153bellings
beltings11369253beltings
beraking153612973beraking_
berlines102315453berl_ines
berlins93216013berl_in_s
bilking144413553bilking_
billings113412633billings
birlings11359613birl_ings
bluings10327963_bluings
bookings15358733bookings
bracings13369293bracings
braking143917713braking_
breakings16297063breakings
brewings14296693brewings
brings94618433br__ings
broking143514823broking_
bulking143815123bulking_
calking144617783calking_
calkins133814873calkin_s
callings113613833callings
carlings114015863carl_ings
caulkings1633353caulkings
ceilings11397993ceil_ings
clings95716213_cl_ings
cookings15358603cookings
crackings18346843crackings
cravings14428223cravings
curlings114110383curl_ings
darklings1533983darklings
darlings103710383darl_ings
dealings103510703deal_ings
deckings16346683deckings
drawings13386283drawings
drillings11285823drillings
drinkings15244773drinkings
drivings13265763drivings
eanlings9128473eanlings
earings84517713e_arings
earnings9419333earnings
earrings9299633earrings
eastings93412953eastings
eatings84616443e_atings
edgings10256243e_dgings
eking106614983e__king_
elains64919853e_lain_s
elfins94810943e_lfin_s
elints65816423e_l_ints
eloigns8425353e_loigns
eloins65419383e_loin_s
emptings1364823emptings
endings92910443e_ndings
erasing8317963erasing_
eringo739553er__ingo
eringos836913er__ingos
ermines9416673er_mines
eroding9314273eroding_
errhines1136413errhines
erring73816483er_ring_
etchings14396293etchings
evenings1234383evenings
evoking1536413evoking_
feelings12338933feel_ings
feltings12317903feltings
filings115213073fil_ings
fillings122910503fillings
flings106715283_fl_ings
flyings14496063_flyings
framings14338133framings
frayings15325993frayings
frillings13265803frillings
gaskings14427473gaskings
geldings11316163geldings
gildings11356973gildings
golfings13304873golfings
gratings103910763gratings
grazings19337263grazings
hawkings19336133hawkings
heelings12359753heel_ings
helpings14255653helpings
herrings12379533her_rings
hildings13347503hildings
holdings13297743holdings
holking153512313holking_
hulking153910983hulking_
hurlings12388213hurl_ings
huskings16276043huskings
inklings13246383inklings
irking114611753ir_king_
ironings9217583ironings
jerking19308923jer_king_
jerkins18358253jer_kin_s
keglings14245233kegl_ings
killings133710483killings
kiltings13327083kiltings
kings105825563___kings
lakings124713513_lakings
lickings15298143lickings
likings12539413_likings
lings67135773__l_ings
lyings10488503__lyings
makings145413163_makings
malkins133311803malkin_s
mallings113413093mallings
markings153410243markings
marlings113713493marl_ings
maskings15448753maskings
merlins93015813merl_in_s
milking143712763milking_
millings113712583millings
moldings12267203moldings
neckings15346113neckings
nervings12256323ner_vings
packings174310063packings
palings103915823pal_ings
parkings153610683parkings
peelings11339523peel_ings
perking143716463per_king_
pickings17359383pickings
pilings103313613pil_ings
pinkings15338143pinkings
prickings18315653prickings
primings13338143primings
pulings103511323pul_ings
purlings113910283purl_ings
racings105015133_racings
raking114728423_raking_
rankings13389173rankings
ratings84217413_ratings
ravings114614503_ravings
readings103512643readings
recking144319923recking_
redwings13305733redwings
reedings103510363reedings
reeking123318643reeking_
reelings94012563reelings
relines75331323rel_ines
relinks114510223rel_inks
relying112914613relying_
ridings93412093_ridings
rings65029173_r__ings
risings83211893_risings
rollings9419953rollings
rovings11439493_rovings
rowings113710363_rowings
rulings83310383_rulings
ryking14348113_ryking_
sackings15389633sackings
saltings92811253saltings
sergings10299213ser_gings
servings12249223ser_vings
silking123715593silking_
slings74618013_sl_ings
stalkings14314983stalkings
sterlings10308753sterl_ings
sulking124514313sulking_
takings124512573_takings
talking123815823talking_
tickings15368583tickings
tilings84212793til_ings
tracings112910413tracings
trackings16247543trackings
troking123514103troking_
trollings10286693trollings
truckings16235023truckings
veilings12357313veil_ings
vikings15386623_vikings
walking154013303walking_
weaklings1794003weaklings
welkins1437173welkin_s
weltings12388203weltings
wickings18357183wickings
wildings13287933wildings
workings16337503workings
wreckings19233683wreckings
wrings104012973wr__ings
writings12298113writings
yealings12257703yeal_ings
yearlings1384203yearl_ings
yerking15368813yer_king_

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621957.70318974.7
3Display Results1951950.0762565.8
 (SQL Overall)1786911958.20221786.3
 
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.