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

421 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
teazling185657(None) 
teazeling1934541teazeling
dealing94323232dea_ling
eagling91113602_eagling
eanling81416672_eanling
feazing205411442feaz_ing
healing113922962hea_ling
pealing104123202pea_ling
pearling11912002pearling
sealing83528562sea_ling
stealing93416602stea_ling
tabling103216032t_abling
tailing82923102t_ailing
teaching143612602teaching
teaming103917592tea_ming
tearing84021492tea_ring
teaseling1036912teaseling
teasing83918512tea_sing
teazelling2043802teazelling
telling83321082te_lling
touzling1835502touzling
trailing92916092trailing
trawling122710782trawling
treadling1137502treadling
vealing114217422vea_ling
weakling16106762weakling
weanling12118642weanling
yealing112716382yea_ling
yeanling12107062yeanling
yearling1297882yearling
ailing74331013__ailing
amazing1938813amaz_ing
availing1267283availing
bailing103723523_bailing
baling94829693_ba_ling
balling104424763_balling
bawling133813863_bawling
beaching164114143beaching
beading113221863bea_ding
beaming123618803bea_ming
beaning103820683bea_ning
bearding124011943bearding
bearing103624773bea_ring
beating104326873bea_ting
bedazzling2241933bedazzling
beetling1139283beetling
befalling15226503befalling
begalling13216493begalling
begazing2136633begaz_ing
belling103825073be_lling
beveling143011033beveling
bewailing1536063bewailing
blazing193612393blaz_ing
brailing113514793brailing
brawling143210043brawling
brazing193715113braz_ing
cabling124017553_cabling
calling103826773_calling
carling103727063_carling
catling104819793_catling
ceasing104118263cea_sing
ceiling103416723ce_iling
celling103921263ce_lling
coaling103722823coa_ling
craaling112711353craaling
cradling122411453cradling
crawling143110513crawling
crazing193914583craz_ing
darling93418363_darling
dazing175516513_daz_ing
dazzling1834363dazzling
deadline10139053deadline
deairing10311893deairing
dealings103510693dea_lings
deaning94020473dea_ning
deashing134210953deashing
deaving123814753dea_ving
defiling132812463defiling
derailing112011313derailing
detailing112510413detailing
develing133212733develing
deviling1311812853deviling
dialing94318173dia_ling
dialling10310783dialling
drawling13318673drawling
eanlings9128463_eanlings
earing75235483_ea_ring
earning83418213_earning
earring83519013_earring
easing74926463_ea_sing
easting84924303_easting
eating75134403_ea_ting
emailing113010043emailing
enabling1138603enabling
exiling15311083_exiling
fabling133413623_fabling
failing113521333_failing
falling113621583_falling
fatling113815683_fatling
fazing194418643_faz_ing
fearing113520033fea_ring
feasing113916653fea_sing
feasting122011323feasting
feeling113617073fe_eling
feezing204610163feez_ing
felling113321133fe_lling
fenagling1434553fenagling
feruling1258873feruling
fettling1266773fettling
fizzling20264993fizzling
flailing12298923flailing
flatling123410013flatling
foaling113515843foa_ling
foozling21275723foozling
frazzling2143153frazzling
gabling113514543_gabling
galling93921963_galling
gaoling93314653_gaoling
gazing174717173_gaz_ing
gearing92818843gea_ring
gelling93219763ge_lling
gentling1048453gentling
glazing183611003glaz_ing
gnarling10217603gnarling
goaling93515333goa_ling
grayling1338003grayling
grazing183514553graz_ing
guzzling18225063guzzling
hailing113820693_hailing
haling104229783_ha_ling
hauling113714433_hauling
hazing194218553_haz_ing
heading122919113hea_ding
headline12129613headline
headlong1334123headlong
heaping133015853hea_ping
hearing113324163hea_ring
hearsing1239383hearsing
hearting12513123hearting
heating114024323hea_ting
heaving144114763hea_ving
heckling18257163heckling
heeling113618513he_eling
heezing20349873heez_ing
heiling113616363he_iling
helling114623223he_lling
jailing153415843_jailing
jazzing2333883_jazzing
jelling153516613je_lling
jeweling1935483jeweling
keckling14245523keckling
keeling123515123ke_eling
kegling13309363ke_gling
kraaling13186663kraaling
ladling92813393_ladling
lalling83519623_lalling
lazing164821473_laz_ing
lazying2046673_lazying
leaching143012833leaching
leading93419553lea_ding
leafing113313583lea_fing
leaguing1035343leaguing
leaking123616963lea_king
leaning83721203lea_ning
leaping103215993lea_ping
learning978553learning
leashing123310313leashing
leasing83920163lea_sing
leaving114216853lea_ving
leveling122910433leveling
mailing102923343_mailing
malling103623663_malling
marling103322763_marling
mauling103315683_mauling
mazing184418973_maz_ing
meaning103918693mea_ning
medaling121912243medaling
medalling1346913medalling
meddling13257933meddling
melling102822623me_lling
metaling111613713metaling
metalling1249593metalling
mewling13329513me_wling
miauling1137343miauling
mizzling19255443mizzling
muzzling19245733muzzling
nailing83419963_nailing
nearing83020333nea_ring
needling10248753needling
nestling958893nestling
nettling957213nettling
nuzzling17224773nuzzling
paling93530133_pa_ling
palling104024483_palling
parling103823763_parling
peaching163613643peaching
peacing124117073pea_cing
peaking144317683pea_king
pebbling1535073pebbling
pedaling122412133pedaling
pedalling1346663pedalling
peddling13217973peddling
peeling102919873pe_eling
peopling1338353peopling
periling11316863periling
pestling111010253pestling
pettling1168213pettling
puzzling19225393puzzling
quailing1838403quailing
railing83325643_railing
razing164524543_raz_ing
razzing1636323_razzing
reaching143317203reaching
reacting113317893reacting
readding11411363readding
reading93327213rea_ding
readying13410223readying
realign838763rea_lign
reaming103924013rea_ming
reaping103621213rea_ping
rearing83128783rea_ring
rearming111413603rearming
reaving113820533rea_ving
recalling122211903recalling
reddling112911813reddling
reedling102414273reedling
reeling83126863re_eling
refalling132010423refalling
refiling123116533refiling
regaling10315363regaling
remailing122412473remailing
renailing102813333renailing
reoiling93217213reoiling
resailing103314253resailing
resiling93520173resiling
resoling92916303resoling
retailing103214733retailing
retiling93319483retiling
reveling123117083reveling
reviling122917213reviling
sailing83927373_sailing
sapling103217863_sapling
scaling103519373sca_ling
seagoing1038193seagoing
seaming103222113sea_ming
searing83330923sea_ring
seating84130683sea_ting
seedling102610953seedling
seeling83522003se_eling
seizing174114833seiz_ing
selling83225833se_lling
settling978943settling
shauling1249393shauling
shawling1558223shawling
shealing123415463shea_ling
shearling1336923shearling
sizzling17225783sizzling
snailing92912973snailing
snarling92513183snarling
spalling113213463spalling
sparling112714523sparling
stabling112913653stabling
staling83925423sta_ling
stalling95116693stalling
stapling112813153stapling
starling93017123starling
steading103613593stea_ding
steadying14154503steadying
stealings10318853stea_lings
steaming114013213stea_ming
steeling93615143ste_eling
sterling93615553ste_rling
tabbing123611913t_abbing
tabuing10308893t_abuing
tacking144421483t_acking
tackling153211123tackling
tagging103014913t_agging
tagline82412453t_agline
tailings93211673t_ailings
taking114725953t_a_king
talcing103111633t_alcing
talking123815823t_alking
tallying12318833t_allying
taming94023433t_a_ming
tamping122815813t_amping
tanging93419523t_anging
tangling101712533tangling
tanking123918793t_anking
tanning83618253t_anning
taping94222393t_a_ping
tapping123317133t_apping
taring73932283t_a_ring
tarring83318303t_arring
tarting84222653t_arting
tasking124616323t_asking
tasting84624213t_asting
tatting84019523t_atting
tattling9259463tattling
tauting83316383t_auting
tawing104521553t_a_wing
tawsing1138673t_awsing
taxiing1535723t_axiing
taxing143816713t_a_xing
taxying1836183t_axying
teachings15296553teachings
tealike111111083tea_like
teaselling1145333teaselling
teazle15329553teazl__e
teazled17326833teazl_ed
teazles16308913teazl_es
tedding103210883te_dding
teeing73916973te__eing
teeming103513093te_eming
teething1237163teething
telexing1646613telexing
temping122710693te_mping
tempting1357343tempting
tenanting1036213tenanting
tending94419163te_nding
tenoning938893tenoning
tensing84616653te_nsing
tenting84621153te_nting
tenuring938863tenuring
terming104015993te_rming
testing86021053te_sting
tewing103914823te__wing
thacking183110043thacking
thanking16409523thanking
thawing14378683tha_wing
thirling12248583thirling
tholing112812333t_holing
thralling13256833thralling
tickling15309433tickling
tiling73426553t__iling
tilling83522773t_illing
tingling102210803tingling
tinkling13239233tinkling
tippling13196703tippling
tirling83315733t_irling
titling83715793t_itling
toadying1335043toadying
toasting93410573toasting
toddling11187003toddling
toenailing1143573toenailing
toggling11206483toggling
toiling83219023t_oiling
toling73926123t__oling
tolling83418563t_olling
tooling82918313t_ooling
tootling9279523tootling
toppling13197353toppling
totaling9610293totaling
totalling1036513totalling
tousling938793tousling
toweling122910373toweling
trachling1537823trachling
tracing103720153tra_cing
tracking153715463tracking
trading93517973tra_ding
traiking132511973traiking
training93015863training
trameling1249053trameling
tramline10311383tramline
tramming13279343tramming
tramping132711273tramping
trampling1436963trampling
trancing112812023trancing
trapline10411863trapline
trapping132911393trapping
trashing122613223trashing
traveling1349053traveling
treading103515333trea_ding
treating92519613trea_ting
trebling1139873trebling
treddling1234423treddling
trembling1435183trembling
trifling122411503trifling
trilling92815963trilling
tripling112712553tripling
trolling93212493trolling
tumbling13219293tumbling
turtling9238833turtling
tussling935823tussling
twaddling1552713twaddling
twanging13287063twanging
twangling1434453twangling
twattling1332693twattling
tweaking1635883twea_king
tweedling1442533tweedling
tweezing21384113tweez_ing
twilling12268673twilling
twirling12246243twirling
vailing113817943_vailing
veiling113615293ve_iling
vialing113614163via_ling
vialling1237223vialling
wailing113620903_wailing
waling104525303_wa_ling
walling113520973_walling
wauling112713113_wauling
wawling143810963_wawling
weaklings1793993weaklings
weaning114117193wea_ning
weanlings1394413weanlings
wearing113318863wea_ring
wearying1546693wearying
weaseling1335613weaseling
weaving143211623wea_ving
wedeling1338773wedeling
welling112920313we_lling
whaling143910773wha_ling
yawling14369183_yawling
yealings12257693yea_lings
yeaning113814633yea_ning
yeanlings1393693yeanlings
yearlings1384193yearlings
yearlong12102573yearlong
yearning1296983yearning
yeasting12188923yeasting
yelling113516703ye_lling
zizzling16233923zizzling

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.1561145455.1
2DLD Change Limit1461624218.33017546.5
3Display Results4214210.1702476.5
 (SQL Overall)1786914218.65620643.6
 
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.